Simple Sumproduct of 2 Columns, with some blank cells in range

Giganews Newsgroups
Subject: Simple Sumproduct of 2 Columns, with some blank cells in range
Posted by:  SteveC
Date: Fri, 12 May 2006

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

Replies