Hi,
I've Date in A1 to A20 Cell Range , Names in B1 to B20 Cell and Amount in C1 to C20
I have to count no of names who don't have date AND whose names >0
secondly sum(Amount) who meet this criteria
for that I tried this
=COUNTIF(A1:A20,"",B1:B20,"*")
But it says you have entered too many arguments for this function
How to do this?
Bookmarks