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.
📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
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.
Thank you a lot! It works!
count rows in a certain month
