# COUNTM for 2 Ranges

Options
✭✭✭✭

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!

• ✭✭✭✭✭✭
Options

And it only outputs 1 when you use

=COUNTM({range 1}) + COUNTM({Range 2})

?

=SUM(COUNTM({1st Sheet}), COUNTM({2nd Sheet}))

• ✭✭✭✭✭✭
Options

@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

• ✭✭✭✭
Options

Hi @Dale Murphy ,

That returns a 1 instead of the total of both which is a few hundred.

Thanks

• ✭✭✭✭✭✭
Options

What do you get when you use them both individually?

• ✭✭✭✭
edited 12/17/21
Options

Then 1 is: about100, and 1 is: about 200

Thanks

• ✭✭✭✭✭✭
Options

And it only outputs 1 when you use

=COUNTM({range 1}) + COUNTM({Range 2})

?

=SUM(COUNTM({1st Sheet}), COUNTM({2nd Sheet}))

• ✭✭✭✭
Options

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!

• ✭✭✭✭
Options

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!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!