I've tried looking for singles ("D") and still get zero.
Could be invisible leading/trailing white spaces somewhere throwing things off
Try TRIM, eg: =SUMPRODUCT(--(TRIM(A2:A10)="D"))
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Doug Mc" wrote:
I'd like to look at a range of columns on each row and count the numbe of
occurances of "R", "D", etc.
I've tried Countif and Sumif and get zero back.
I've tried looking for singles ("D") and still get zero.
Any ideas?