I have a table of data with text strings. I need to count the number of instances of each text string, which I have done with a simple COUNTIF. But I also need to count them if the date in the column header is after today.
I have been trying COUNTIFS but can't get it right. Any help is appreciated.
Excel example.PNG
=SUMPRODUCT(($A$2:$BB$5=A9)*($A$1:$BB$1>TODAY()))
but countif
=COUNTIF($A$2:$BB$5,A9)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Change the formula in B9 to this:
=COUNTIF($2:$5,A9)
(i.e. use $ symbols in front of the row references so that they do not change). You can use this formula in cell C9:
=SUMPRODUCT(($2:$5=A9)*($1:$1>=$A$7))
Copy both formulae down to the bottom of your key.
Hope this helps.
Pete
Thanks for the rep, given about an hour ago.
If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks