Countif on a Specific Column Header versus a specific Column

**usc1382** · 05-18-2012, 10:18 AM

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!

**NBVC** · 05-18-2012, 10:44 AM

You can use COUNTIFS...

e.g

in D2:

=COUNTIFS($A$2:$A$6,A2,$B$2:$B$6,205)

copied down

**usc1382** · 05-18-2012, 10:58 AM

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

**NBVC** · 05-18-2012, 11:01 AM

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.

**usc1382** · 05-18-2012, 11:04 AM

Perfect. Thanks!

**Cup V Joe XL** · 05-18-2012, 11:12 AM

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.

**junierashish** · 07-14-2020, 02:40 AM

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

**AliGW** · 07-14-2020, 02:41 AM

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