Hi all,
I want to take the count of dates in column 1 if the relevant column 2 value is equal to "aa" or "bb" and the dates should be with the 2 days before today's date. please help
9/11/2014 - aa
9/11/2014 - aa
9/11/2014 - bb
9/5/2014 - aa
9/10/2014 - cc
9/10/2014 - dd
9/8/2014 - ee
I tried below formula but it didn't work
=SUM(COUNTIFS(E16:E25,{"aa","bb"},C16:C25,{today()-24/24;today()-48/24}))
Try (untested)
in C1
=SUMPRODUCT(((B1:B7="aa")+(B1:B7="bb"))*(A1:A7>TODAY()-2))*(A1:A7<TODAY())
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hmmmmmm the answer should be 4, it gives me only 2
The answer should be 3
There are a total of four aas and bbs
But only 3 of them are within the last 2 days.
Change > to >= in the above
Thanks it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks