CODEWITHSUNDEEP
excelsumifs
L.Dutch
L.Dutch

Reputation: 966

SUMIF not returning the expected result

I want to sum the content of some cells only if the corresponding label correspond to a given string.

I used the following formula in B1=SUMIF($E$1:$E$6,"LEFT(E1,13)=A1",$F$1:$F$6)

but the result is not what I expect

enter image description here

Upvotes: 0

Views: 93

Answers (1)

Rdster
Rdster

Reputation: 1872

Easiest way I can think of is to make another column (say D) that = =Left(E1,13)

Then drag it down...then change your B formulas to =SUMIF($D$1:$D$6,A1,$F$1:$F$6)

Upvotes: 1

Related Questions