Combining COUNTIFS formulas
Currently I have two COUNTIF formulas in two different cells, then I am using a 3rd cell to add them together. I am looking for a way to combine the formulas and have everything calculated in one cell. Both formulas are pulling data from different sheets.
1st formula:
=COUNTIF({B2B Thermo Fisher Project List Range 1}, IF(ISDATE(@cell ), MONTH(@cell )) = 1)
2nd formula:
=COUNTIF({Completed Projects Units}, IF(ISDATE(@cell ), MONTH(@cell )) = 1)
I have tried to combine the formulas into one cell, but am getting a #UNPARSEABLE error. The formula I tried was: =COUNTIFS({Completed Projects Units}, IF(ISDATE(@cell), MONTH(@cell) = 1), {B2B Thermo Fisher Project List Range 1}, IF(ISDATE(@cell), MONTH(@cell) = 1))
Best Answer
-
Just add the two COUNTIF formulas together.
=COUNTIF(………………) + COUNTIF(……………)
Answers
-
Just add the two COUNTIF formulas together.
=COUNTIF(………………) + COUNTIF(……………)
-
Thank you, Paul. I could have sworn I tried that and got an error. I tried again and it worked.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!