LinkBack URL
About LinkBacks
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
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
Blank cells (meaning empty) are treated as zeros; they don't affect the result.
Explain further?
Entia non sunt multiplicanda sine necessitate
I also have titles in each of the 12 tables in the range would that effect the result
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...
=sumproduct( $a$5:$a$308=$a315, b$5:b$308)i also have titles in each of the 12 tables in the range would that effect the result
If A315 contains text, then you'll need to modify shg's formula (I think) to
=sumproduct(--( $a$5:$a$308=$a315), b$5:b$308)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks