Forum Discussion
Count Value and blank cell using today' date criteria
Hi Quadruple,
Much appreciated for the help.
The formula is working as the end result is the same as i want, however, when date is change is not counting.
As per today's date, it is counting only the empty cell ("D14") not adding out the cell value like count of "TUE" or "DI" and so for the other days.
Can you please look into again?
Thank You,
=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,
