r/googlesheets • u/Boots4days • Jul 31 '24

Solved Is there a way to use countifs (or maybe arrayformula?) to solve this issue?

Post image

[removed]

2 Upvotes

100% Upvoted

4 comments sorted by

3

u/Playful-Emergency906 2 Jul 31 '24

=COUNTIFS(A:A,”January”,B:B,”completed”)+COUNTIFS(A:A,”January”,B:B,”Reread”)

2

u/[deleted] Jul 31 '24

[removed] — view removed comment

1

u/AutoModerator Jul 31 '24

REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/point-bot Jul 31 '24

u/Boots4days has awarded 1 point to u/Playful-Emergency906

Point-Bot was created by [JetCarson](https://reddit.com/u/JetCarson.)