View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
 
Posts: 258
Default Help with Count, CountIf, Sum Functions

Hi Kris,

I need to know how many are in A but don't have anything in B:
=SUMPRODUCT(--ISNUMBER(A1:A4),--ISBLANK(B1:B4))

How many are in C but don't have anything in A or D:
=SUMPRODUCT(--ISNUMBER(C1:C4),--ISBLANK(A1:A4),--ISBLANK(D1:D4))

Regards,
Ivan