Thread: need your help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Malik Malik is offline
external usenet poster
 
Posts: 47
Default 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