Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need your help
i am creating Mess management sheet and has format that if someone is present
for the particular time i put "p" as present and "a" and count all presents and absents by using COUNTIF(C17:BL17,"p") but the problem is that how to count 2p as twice if someone has guest with him etc |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need your help
If you enter 2p to represent a guest, do it like this:
=COUNTIF(C17:BL17,"p") + COUNTIF(C17:BL17,"2p")*2 Hope this helps. Pete On Feb 16, 7:55*pm, malik wrote: i am creating Mess management sheet and has format that if someone is present for the particular time i put "p" as present and "a" and count all presents and absents by using COUNTIF(C17:BL17,"p") but the problem is that how to count 2p as twice if someone has guest with him etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|