Is SUMIF the correct formula here because it doesn't seem to be working...

[iamanexcelnoob]

hey all - i am back again.

so i am trying to sum up H5:L81 if the corresponding text in F5:F81 = "ABC123".

for some reason it is not pulling when i use the following forumula

=SUMIF(F5:L81, F5:F81="ABC123")

what am i doing wrong?

thanks!

 

[Special-K99]

So if F5="ABCDEF" what do you want to sum? The whole row of H5:L5 or something else?

 

[iamanexcelnoob]

So if F5="ABCDEF" what do you want to sum? The whole row of H5:L5 or something else?

when the criteria is met in column F, i want to sum the entire corresponding row within array H5:L81

 

[Special-K99]

=sumproduct((f5:f81="abcdef")*(h5:l81))

 

[JPGKIll3R]

when the criteria is met in column F, i want to sum the entire corresponding row within array H5:L81

If you want to sum the CORRESPONDING row, you should go with something like this:

=SUMPRODUCT((F5="ABCDEF")*(H5:L5))

Else, you shoud go with Special-K99's approach, adding the entire range's values, instead of the CORRESPONDING row.