Inconsistent COUNTIFS() function

[paras7]

Hi,
I've data in three columns as
Cathode Make, Age, BT
Sgl, 900, 970
Yunnan, 2100, 965
Sgl, 250, 978
Yunnan, 1678,969
Xhanxi, 299, 962
Xhanxi, 1890, 970
Sgl, 210, 971
Now I wish to count the no of readings in column 3(i.e. BT) Which are >970 with corresponding value in column 1(i.e. Cathode make)=Sgl and values in column2(i.e. Age) falling between 60 & 300.

I'm doing this with countifs function(along with AND function for >60, <300 condition), but it's not giving the desired result.

Kindly help.

Regards
Paras

 

[FormR]

Hi, something like this?

Excel 2013
	A	B	C	D	E
1	Cathode Make	Age	BT
2	Sgl	900	970		2
3	Yunnan	2100	965
4	Sgl	250	978
5	Yunnan	1678	969
6	Xhanxi	299	962
7	Xhanxi	1890	970
8	Sgl	210	971
Sheet1

Cell Formulas
Range	Formula
E2	=COUNTIFS(A2:A8,"SGL",B2:B8,">=60",B2:B8,"<=300",C2:C8,">970")

 

[Special-K99]

COUNTIFS doesnt require an AND, all the conditions must be true for a cell to be counted, hence it uses AND by its very nature.

=COUNTIFS(A2:A8,"Sgl",B2:B8,">60",B2:B8,"<300",C2:C8,">970")

 

[paras7]

Hey thanks a lot for the prompt response!
but this thing is still not working, actually i've kept data in one sheet(DRF-R2) and the formula in other.
I'm using this formula

=COUNTIFS('DRF-R2'!C3:C40,"SGL", 'DRF-R2'!E3:E40,">60", 'DRF-R2'!E3:E40, "<300",'DRF-R2'!R3:R40,">970")

I'm getting 0 as the result.

 

[Jonmo1]

That picture doesn't help at all.
Formula references column C E and R, but the picture doesn't tell us which column is which..
And NONE of the numbers in the picture are between 60 and 300, or over 970.
And NONE of the values = SGL

Pictures generally don't help anyway, we can't copy paste the values into our own sheets for troubleshooting.
See my signature for a link to an HTML tool that will help you post nicely formatted tables from your sheet to the forum.

 

[paras7]

hey, apologies!

i agree pictures doesn't solve the purpose here. I guess my formula is working now, to be honest i didn't had values which matched the criteria. Altered few of them and verified the consistency, its actually working.
Thanks again