Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct question
Hi team
Ive a sheet at work with the names of patients & wich room they are in. I count the 'census' with sum product: =SUMPRODUCT(--(LEN(A1:A10)=2),--(LEN(A1:A10)<=30)) As you see, I count anything from a patient whos intials only have been entered in the sheet up to their full name. Is there anyway I can exclude counting "guest" if a family member is in one of the patient rooms (the phrase "guest" is entered in the sheet)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct question | Excel Worksheet Functions | |||
Sumproduct question | Excel Worksheet Functions | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
Sumproduct question | Excel Worksheet Functions | |||
SUMPRODUCT Question | Excel Worksheet Functions |