COUNTIFS- Sheet Summary
I had several Sheet Summaries entered and pulling in to a dashboard. Not sure what happened, but they are all non functioning. I am having a total brain lapse on how I accomplished the summaries below.
I had a summary formula to COUNT the total "ASA's" expiring each month. I can't even remember if I used the Month and Year columns I entered (=Month/=Year} or if I accomplished the summary by month with a different formula. Any help is appreciated as I am getting no where with my efforts!
d
Answers
-
If you want to reach out to me on email I'd be happy to Zoom with you and see if we can establish the formulas again.
Debbie.sawyer@smarterbusinessprocesses.com
Kind regards
Debbie
-
Hi @Smarty,
Here is a formula to count the rows containing the year 2023. You can copy this, and replace the year for each of the countif formulas you're trying to recreate.
=COUNTIF(Year:Year, 2023)
Hope this helps!
BRgds,
-Ray
-
@Ray Lindstrom @Debbie Sawyer Thank you both for replying. This was such a beginner question (and I am not a beginner), but came across something I had not encountered before. One of the cells in the "ASA Exp Date" date formatted column had a non-date entry, way, way down in the column. When the formula was hitting this cell, resulted in an error. I was about to pull my hair out, but finally figured it out. Thank you again for replying.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!