Thread: Function Help Please

I have a worksheet it has one column labeled premier. It can be either a "P" or "N". That column is D. Then i have another column E labeled PPO. It can be either "Y" or blank "".

I need a function if:

If column D is "N" and Column E is "" (blank) add all of these up to a number.

I tried the function:

Countif(D2:d9883="N")and(Countif(e2:e9883=""))
*I thought this would give me the total number if it had an N and blank it takes a 1 and adds 1 for each one and gives me a number say 1,045 (this would be how many records satisfy the N and ""(blank)

Any ideas?

Hi,

You could try

=SUMPRODUCT(--(D2:D9883="N")*(--(E2:E9883="")))

VBA Noob

Originally Posted by VBA Noob

Hi,

You could try

=SUMPRODUCT(--(D2:D9883="N")*(--(E2:E9883="")))

VBA Noob

Thanks a lot I figured it out before i got a response works like a charm.

THANKS A LOT!