=sumproduct(--(A1:A10=""),--(C1:C10=""),B1:B10)

as an example.

--
Regards,
Tom Ogilvy


"Kris" wrote:

> I am having the worst time trying to wrap my head around this function.
> I just can't seem to visualize how to do this. I have a spreadsheet
> with the following:
>
> A B C D
> 1 6 9
> 2 6 8 8
> 3 7 3
> 4 3 5 8
>
>
> I need to know how many are in A but don't have anything in B. How many
> are in C but don't have anything in A or D. Things of this nature but I
> just can't seem to find a way of doing it. I am currently using the
> functions in this order SUM, COUNTIF, IF but it is returning incorrect
> results. Can anyone out there with a better math mind help me to figure
> this out.
>
>
> Thanks so much
>
> Kris
>
>