| 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) | |||
Linear Mode
