|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
COUNTIF
DA! Thanks to both.
"Max" wrote:
Use 2 countifs, eg:
=COUNTIF(A1:C10,"1")+COUNTIF(G50:X60,"1")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ronbo" wrote:
What is the formula (syntax) for counting multiple ranges? I have looked,
and suprisingly not found anything on it.
I am trying to find the number of occurences of a number 1 in ranges A1:c10
and G50:X60.
Thanks for any help
|