Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells with text
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells with text
=SUMPRODUCT(--(machine_range=machine_id),--(comment_range<""))
-- __________________________________ HTH Bob "neiltb" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells with text
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells with text
"neiltb" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Cells With Text | Excel Worksheet Functions | |||
Counting cells that don't contain certain text | Excel Worksheet Functions | |||
Counting cells with text | Excel Worksheet Functions | |||
Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
counting text cells | Excel Worksheet Functions |