Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help of you people
Hope you all would be fine. I am making a Mess Management sheet for employees
but i have a problem that i make "P" for present in mess and "a" for absent before anyone's name according to date i count all "p" and all "a" by COUNTIF but the problem is how to make the value of 2p twice if some one has guest with him when in geting total of all presents(p). plz guide urgently Thanks alot |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help of you people
Hi,
if you only have p , a and 2p then =COUNTIF(E1:E7,"p*")+COUNTIF(E1:E7,"2P") or =SUMPRODUCT(COUNTIF(E1:E7,{"p*","2p"})) -- If this helps, please click the Yes button Cheers, Shane Devenshire "malik" wrote: Hope you all would be fine. I am making a Mess Management sheet for employees but i have a problem that i make "P" for present in mess and "a" for absent before anyone's name according to date i count all "p" and all "a" by COUNTIF but the problem is how to make the value of 2p twice if some one has guest with him when in geting total of all presents(p). plz guide urgently Thanks alot |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help of you people
Hi,
And here is a way to handle any number preceeding the P =SUM(--IF(MID(E1:E7,2,1)="p",LEFT(E1:E7)))+COUNTIF(E1:E7, "p") This is array entered, meaning you need to press Shift+Ctrl+Enter to enter it. -- If this helps, please click the Yes button Cheers, Shane Devenshire "malik" wrote: Hope you all would be fine. I am making a Mess Management sheet for employees but i have a problem that i make "P" for present in mess and "a" for absent before anyone's name according to date i count all "p" and all "a" by COUNTIF but the problem is how to make the value of 2p twice if some one has guest with him when in geting total of all presents(p). plz guide urgently Thanks alot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do people use SUM() unnecessarily? | Excel Discussion (Misc queries) | |||
Hi people views once what I received: | Excel Worksheet Functions | |||
Hi people views once what I received: | Excel Discussion (Misc queries) | |||
Two People Using Same File | Excel Worksheet Functions | |||
Calculating number of people | Excel Discussion (Misc queries) |