|Subject:||Simple Sumproduct of 2 Columns, with some blank cells in range|
|Date:||Fri, 12 May 2006|
I'd like to sum the products of the two columns, while ignoring rows that
have a blank cell, so in this case (5*10) + (5*10) + (5*10) --->it's
skipping the third row.
I'm not having luck adjusting a simple =sumproduct(ColA,ColB) formula. I
did a search but didn't come up with anything that I understand how to
Thanks for your help!