Hello all,
I have a spreadsheet with dates across the top row and multiple rows of data underneath
I am trying to HLOOKUP to get todays date then count the number of times a particular data string appears across all rows in that column
E.g. count of the number "2" across all rows
Looking for some guru help
Regards
Last edited by sadsack5000; 05-11-2020 at 09:07 AM.
try
=COUNTIFS(INDEX(datarange,,MATCH(today(),headerrange,0)),criteria)
datarange , your data
header range , you headers
assuming the data is in C to K row 2 to 2000
=COUNTIFS(INDEX(C2:K2000,,MATCH(today(),C1:K1,0)),2)
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.
This worked really well thankyou
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks