Count Same Number in three ranges

[RJB]

Need a formula that will count the number of occurrences of that same number in three different ranges. The number that is to be compared to is in a cell that is a result of a formula. Example:
Lowest number found in three ranges: 30 (Answer is in A1)
Question: how many times does that number appear in the three ranges?
Syntax:
=Countif(Range1,range2,range3=A1)
Has to equal the cell reference value (A1), not a plain number (like 30)

 

[dakota]

fantastic, I had not tried that yet.

 

[dakota]

Now I need to create a Macro that read the new weekly report and increments that counts
Example
This week Sam Spade = 4
Next week Sam Spade has 2 error's so New total would be 6
report name is the same each week

 

[guthrie]

countif over non-contiguous ranges...

Thanks for the neat hint -
but note that one must have separate named contiguous rectangular sub-ranges, one cannot have one name over discontinuous cells.



Dear Microsoft, why not fix this!
I think that reading the countif and range definitions, this should work.[/b]