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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Age[/TD]
[TD]Mon[/TD]
[TD]Tues[/TD]
[TD]Wed[/TD]
[TD]Thurs[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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