Try sumproduct for multiple criteria
Something like this in say F2:
=SUMPRODUCT((D$2:D$100="Machine ID")*(TRIM(E$2:E$100)<""))
assuming col D = machine ids, col E = comments
TRIM is suggested to screen off the possibility of white spaces in col E's
comments, which would otehrwise give spurious counts.
Any worth? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"neiltb" wrote:
I am trying to count cells that have text in them but using a second column
as a criteria also.
ie I have a column 'machine' and a colum ' comment'. I want to be able to
count the amount of times a particular machine has a comment attached (there
are 15 machines and there may or may not be a comment).
neil