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:
<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
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