Forum Discussion
Count Value and blank cell using today' date criteria
=SUMPRODUCT(N(TEXT(A2,"TTT")=Report!$B$2:$B$27))+IF(A2=TODAY(),COUNTIF(Report!$A$2:$A$27,"="&""),0)
Can you enter this formula in your sheet. The first suggestion had Report!A2:A27 instead of Report!$A$2:$A$27 i'm afraid. The dollar signs ($) were missing.
What version of Excel do you work with? The "TTT" part of the TEXT formula wasn't translated : TEXT(A2,"TTT") . T is for german "Tag", in english excel you'd have to enter D for "day": TEXT(A2,"DDD") . Does it work if you enter the equivalent for "TTT" or "DDD" according to you excel version?
Hi Quadruple,
Great..!
Thanks for help and guiding me.
Its work now, Here is the screen shot of my test data.
Your prompt assistance is greatly appreciated.
Just curious, how did you apply logic here? I mean a bit of explanation of how this formula works would be greatly appreciated. (Just want to learn the function).
Thank you,