SUMPRODUCT Help with Blanks

[MIVELD]

Hi All

I am using the following formula

SUMPRODUCT(($A$5:$A$308=$A315)*(B$5:B$308))

Challenge is i have empty cells in the columns and cannot remove them

Any Ideas how i can get the Sumproduct to ignore the empty cells

Regards

[shg]

Blank cells (meaning empty) are treated as zeros; they don't affect the result.

Explain further?

[MIVELD]

I also have titles in each of the 12 tables in the range would that effect the result

[Cheeky Charlie]

You could, of course, test these things by putting values in/out of the blanks and title spaces to see what effect (none in this case) it has...

[shg]

i also have titles in each of the 12 tables in the range would that effect the result

=sumproduct( $a$5:$a$308=$a315, b$5:b$308)

[ChemistB]

If A315 contains text, then you'll need to modify shg's formula (I think) to

Please Login or Register  to view this content.