multiple count if statements help

[squeakums]

I need to count if these two statements; how would I write that please?

=countifs(H:H=3,L:L>60) also if H:H=1,L:L>40

 

[Joe4]

You can put multiple conditions in COUNTIFS. They are always in sets of two:
FIRST, the range you wish to check
SECOND, the criteria/condition you want to check on that range

See here for a full explanation and examples: MS Excel: How to use the COUNTIFS Function (WS)

 

[Eric W]

Try:

=COUNTIFS(H:H,3,L:L,">60")+COUNTIFS(H:H,1,L:L,">40")

 

[etaf]

=COUNTIFS(H:H,3,L:L,">"&40)
AND
=COUNTIFS(H:H,1,L:L,">"&60)

you can add together in 1 formula

=COUNTIFS(H:H,3,L:L,">"&40) + COUNTIFS(H:H,1,L:L,">"&60)

Book1
	B	C	D	E	F	G	H	I	J	K	L	M
4	countifs(H:H=3,L:L>60) also if H:H=1,L:L>40
5							3				1
6	6						3				60
7							1				87
8
9							3				70
10							3				1
11							1				70
12
13							3				41
14							3				43
15
Sheet1

Cell Formulas
Range	Formula
B6	B6	=COUNTIFS(H:H,3,L:L,">"&40)+COUNTIFS(H:H,1,L:L,">"&60)

 

[Joe4]

OK, I think I totally misread that question.
My apologies.