Count in a Col depending on another column?

[HuskyJones]

Hi Folks
Having a brain fart......
On my "counts" sheet I want to get the number from a column in my KCPs sheet but only to be counted if cells another column in KCPs contains a specific value (T1).....
I thought this
=COUNTIFS(KCPs!$H$2:$H$10000,"T1",KCPs!$K2:$K10000,<>"")

(My K column is weight, My H column is Type and i want a count of T1 with weight, then i'll repeat for T2)

I know my brain is farting but can't see it for looking

Thanks ever knowing peeps

 

[AlanY]

try replace "T1" with T1

 

[HuskyJones]

nope's still get the "problem with formula" message
Thanks though

 

[HuskyJones]

try replace "T1" with T1

I bet it's because my T1/T2 is a formula itself isn't it ****

 

[Joe4]

ADVERTISEMENT

The issue is with your last argument.
Try:

[COLOR=#333333]=COUNTIFS(KCPs!$H$2:$H$10000,"T1",KCPs!$K2:$K10000,[/COLOR][COLOR=#ff0000]"<>"[/COLOR][COLOR=#333333])[/COLOR]

If you are looking the for specific value "T1", use quotes around that.
If you are looking for the value in cell T1, leave the quotes off. It doesn't matter if T1 is hard-coded or a formula, as long as it is not returning an error in that cell.

 

[HuskyJones]

the issue is with your last argument.
Try:

=countifs(kcps!$h$2:$h$10000,"t1",kcps!$k2:$k10000,"<>")

if you are looking the for specific value "t1", use quotes around that.
If you are looking for the value in cell t1, leave the quotes off. It doesn't matter if t1 is hard-coded or a formula, as long as it is not returning an error in that cell.

thank you joe you are my saviour!!!!!

 

[AlanY]

deleted

 

[Joe4]

You are welcome.