Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help of you people
Dear Shane Devenshire
your formula works but there is some problem that as i am managing the sheet for the month of feburary and the dates are in Row and your statement SUM(--IF(MID(E1:E7,2,1)="p",LEFT(E1:E7)))+COUNTIF(E1:E7, "p") gives the total no of presents (p) right but rights it as 17-jan(previous month with it). hope you can tackle this also cheers waiting for urgent response from you thanks alot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help of you people | Excel Worksheet Functions | |||
Trying to average the top ten lists from several people | Excel Worksheet Functions | |||
Why do people use SUM() unnecessarily? | Excel Discussion (Misc queries) | |||
Two People Using Same File | Excel Worksheet Functions | |||
Calculating number of people | Excel Discussion (Misc queries) |