countif formula

[bwpscmw]

Hi

I am struggling to get a countif / countifs formula to work for me. I need to count values in one column if they match a value in another column. Example below:

Age	Mon	Tues	Wed	Thurs
3	1	1	1
2		1		1
3	1	1
Total

<tbody>
</tbody>

So I need to know how many children age 2 attend each day and how many children age 3 and above (some might be 4) attend each day (basically to calculate adult/child ratios). I need to use a COUNT formula instead of a SUM formula for a separate (but similar) problem on another sheet.

I have tried =SUM(COUNTIFS(A2:A4,{"3","4"},B2:B4,"")), but it does not seem to be working.

Any ideas?

Many thanks

 

[pgc01]

Re: countif formula - help needed

... how many children age 3 and above (some might be 4) attend each day ...

If I understand correctly, assuming the values posted are number values, in B5:

=COUNTIFS($A$2:$A$4,">=3",B2:B4,1)

Copy across