Hi!

Try this:

=SUMPRODUCT(--(B2:B5=""),A2:A5,C2:C5)

Biff

"gmunro" wrote in message
ps.com...
Hello,

I am trying to determine a sumproduct for two ranges but only for rows
where data is not present in a third range

For instance

The range a2:A5 has the following values
2
1
1
1

The range C2:C5 has the values
5
10
15
18
The range B2:B5 are empty except cell B3

I want to write a formula that will give me the sum product of A2&C2,
A4&C4, A5&C5

Cells in range B2:B5 may vary if empty or not
The A & C ranges will be of variable length and values

Any help is appreciated

Glen