You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hi!
I want to create a statistics in apple numbers and I need to count rows for each month.
In October I have two values.
In November I have one value.
How to count then? I’d like to avoid „dates between” if is possible.
Summary I need „count rows where dates in a certain month and other column equal a certain value form another table”. I believe you can help me.
MacBook Air 13″, macOS 13.1
Hi KacperPiotrowski,
The functions MONTH and COUNTIF are your friends.
formula in Table 1 B2: MONTH(A2)
You can hide Column B if you like.
Month numbers in Table 2, Column A are typed in.
Formula in Table 2 B2: COUNTIF(Table 1::B,"="&A2)
Regards,
Ian.
Hi KacperPiotrowski,
The functions MONTH and COUNTIF are your friends.
formula in Table 1 B2: MONTH(A2)
You can hide Column B if you like.
Month numbers in Table 2, Column A are typed in.
Formula in Table 2 B2: COUNTIF(Table 1::B,"="&A2)
Regards,
Ian.
Thank you a lot! It works!
count rows in a certain month
