View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteveC
 
Posts: n/a
Default Simple Sumproduct of 2 Columns, with some blank cells in range

ColA ColB
5 10
5 10
5
5 10

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
adjust.

Thanks for your help!
SteveC