countif based on another column

[stephme55]

How do I count numbers in one column based on values in another column. Count column A, if column B= x, for example.

[hemesh]

=sumproduct(isnumber((B1:B100="X")*(A1:A100))*1)

[stephme55]

I tried this but it didn't work =COUNTIFS(E1:E74478,F1:F74480=HVAC)

E is the column I want to count based on criteria in column F.

[stephme55]

Hi Hemesh. I tried that but it didn't work. Maybe I'm not applying it right.

[hemesh]

I tried this but it didn't work =COUNTIFS(E1:E74478,F1:F74480=HVAC)

E is the column I want to count based on criteria in column F.

you could give a try to

=SUMPRODUCT(--(((F1:F74478="HVAC")*(E1:E74478))>0))

[MrShorty]

What does the name HVAC refer to? Or, is this really supposed to be the text string "HVAC"?

Can you explain what the difference is in your actual data between "how many entries in column F are "HVAC?" and how column E actually fits into your desired calculation? It seems to me that, unless there is a second condition based on column E, then a conditional count of column F is adequate. If you need to place a condition on column E, it should be as simple as using the COUNTIFS() function =COUNTIFS(F1:F74480,"HVAC",E1:E74480,condition for column E).

[stephme55]

Hi Hemesh. I tried that but it didn't work. Maybe I'm not applying it right.

[stephme55]

Actually, I confused myself haha. Sorry I'm going to close this one and reopen a different thread because the question is slightly different. Thanks.

[hemesh]

what did you try, I updated formula, Can you please upload a sample book to know whats actually there