How to count number of rows that have at least one numeric value?

can provide a formula that counts number of rows have @ least 1 numeric value in c:l in row, without relying on helper cells?

the formula must work in excel 2003.

see image below. can download file "count rows conditions.xls" (click here). [1] ignore preview errors. download file.

the formula in m3 =sum(n6:n19) .

the formulas in n7:n19 of form (showing n7; n6 empty): =--(count(c7:l7)>0) .

note ryan has no 1s in row. ryan should not counted in m3.

-----

[1] https://app.box.com/s/5ytmtyiews42p6p9fsum83fnv5633bt4

enter below formula array formula (ctrl+shift+enter):

=sum(--(frequency(if(c7:l13<>"",row(c7:l13)),row(c7:l13))>0))

counts non-blank rows.

regards,

amit tandon

www.globaliconnect.com

Office / Excel / Other/unknown / Unknown/other

Cororate