Counting cells with text

  • Thread starter Thread starter neiltb
  • Start date Start date
N

neiltb

H,

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
 
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 said:
H,

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
Click to expand...
 
Back
Top