COUNTM for 2 Ranges

A Rose

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!

Paul Newcome

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}))

Dale Murphy

@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

A Rose

Hi @Dale Murphy ,

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

Thanks

Paul Newcome

What do you get when you use them both individually?

A Rose

@Paul Newcome

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

Thanks

Paul Newcome

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}))

A Rose

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!

A Rose

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!

Paul Newcome

Happy to help. 👍️