Counting disjointed cells

Hi and welcome to the forum.

Can you just clarify? Do you want help with this:

Originally Posted by Milgod

I want to count the cells if they are empty of if they have a value. I just want the total number of cells whatever is in them - even blank.

or this:

Originally Posted by Milgod

I'll make another formula for counting the number of these cells that have a specific value - to then work out the %.

or both?

The first is straightforward, e.g.:

=AREAS((B24,B25,B28,B31))

The second is a little more complex, particularly since your cells are not equally spaced apart, e.g.:

=SUM(COUNTIF(INDIRECT({"B24","B25","B28","B31"}),YourValue))

where you should replace YourValue as required.

Regards

Originally Posted by Milgod

Is AREAS the general thing to use to count a range that isn't continuous?

It's one option, and will work whether those cells are empty or not.

Regards

Originally Posted by Milgod

I might need to have to count different values (any cell that contains 11 or 22 or 33.

You could use:

=SUM(COUNTIF(INDIRECT({"B24","B25","B28","B31"}),{11;22;33}))

though it's preferable to have your values (11, 22 and 33) in a contiguous range within the actual worksheet, e.g. E1:E3, after which the above becomes:

=SUMPRODUCT(COUNTIF(INDIRECT({"B24","B25","B28","B31"}),E1:E3))

Regards

Sure. You're welcome.

Cheers