COUNTM for 2 Ranges
Hi,
How can I count a total of values, in 2 diferent columns that are in 2 deiferent sheets?
I need something like this..
=COUNTM({Range 1} AND({Range 2})
Thank you!
Best Answer

And it only outputs 1 when you use
=COUNTM({range 1}) + COUNTM({Range 2})
?
That is odd. What about this?
=SUM(COUNTM({1st Sheet}), COUNTM({2nd Sheet}))
Answers

@A Rose If you can get COUNTM to work separately for both ranges, why not just put a plus sign between them?
=COUNTM ({range 1}) + COUNTM({Range 2})
dm


What do you get when you use them both individually?


And it only outputs 1 when you use
=COUNTM({range 1}) + COUNTM({Range 2})
?
That is odd. What about this?
=SUM(COUNTM({1st Sheet}), COUNTM({2nd Sheet}))

Hi @Paul Newcome ,
Yes, even if I just copied your exact formula: =COUNTM({range 1}) + COUNTM({Range 2}) into a cell, it says 2!
But your second formula showed the correct numbers!
Thank you so much!

Hi @Paul Newcome ,
Update, I guess when I copied your formula the first time I didn't change the formula to the correct reference which caused the "2" to show up, but now I tried again and it worked! both work!
Thank you!

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!