#### UniMord

##### Active Member

- Joined
- May 6, 2002

- Messages
- 311

For example

*(assuming all cells contain numbers)*.

**=COUNT(A1:J1, A1:J1)**returns 20 instead of 10.

**=COUNT(A1:B1, A1:A2)**returns 4 instead of 3.

*(SUM for instance)*, but with COUNT, we're looking for the count in all the ranges together, it shouldn't be double counting. For the record, the status bar gives the correct count.

Is there a practical workaround?

For just 2 ranges, we can use:

**=COUNT(A1:B1, A1:A2) - COUNT(A1:B1 A1:A2)**