LinkBack URL
About LinkBacks
Hey,
I am trying to complete a countif of a certain column based on the header of a column versus just doing a countif on the range of a specific column. Please see the attached file for guidance. Thanks in advance for the assistance!
Hey,
I am trying to complete a countif of a certain column based on the header of a column versus just doing a countif on the range of a specific column. Please see the attached file for guidance. Thanks in advance for the assistance!
You can use COUNTIFS...
e.g
in D2:
=COUNTIFS($A$2:$A$6,A2,$B$2:$B$6,205)
copied down
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks. I am actually trying to get the count of 205 in column labeled StatusCode. Therefore, regardless of which column StatusCode (currently column B) shows up the results will show 3 in 205 and 2 in 225. I am not sure how to isolate the StatusCode column regardless of where it can show up in the sheet versus normally assigning just a column as the range
Do you mean then, something like:"
=COUNTIF(INDEX($A$1:$S$6,0,MATCH("StatusCode",$A$1:$S$1,0)),205)
where A1:S6 is the entire range, and the Match finds what column the StatusCode header is in and then counts the 205's in that column.
Perfect. Thanks!
I found this formula to work =COUNTIF(B1:B6,205) that way it will only return the accounts if its associated with 205. Or are you trying to return the name also that associated with 205? Hope that helps.
Hi Buddy thank you so much, what I need to add here is multiple condition like Trainers name = Ashish and program name should be Induction. Please help
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks