I want to sum the values corresponding to E1 only.
Hereby a screenshot:
I tried using a vlookup and sum formula, but that didn't seem work. Any solutions?
Thanks!
I want to sum the values corresponding to E1 only.
Hereby a screenshot:
I tried using a vlookup and sum formula, but that didn't seem work. Any solutions?
Thanks!
This is the reason for which the SumIf()
worksheet function exists, like in this example:
Formula: =SUMIF(B2:B10,"E1",A2:A10)
Screenshot: