| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lose the 0 in the Total cell
"Gary''s Student", Hi,
Please forgive me. I am not worthy. I got it to work. You were right and I am a worm. LOL Thank you, Best regards, Malcolm "Malcolm" wrote: "Gary''s Student", Hi, I copied and pasted your solution into the formula bar and all it returned was the formula itself in the Total cell. I then tried to enter the formula myself and got the same results. Sorry dude, this didn't work. Regards, Malcolm "Gary''s Student" wrote: =IF(COUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s")=0,"",C OUNTIF(B5:B22,"s")+COUNTIF(H5:H21,"s")) -- Gary''s Student - gsnu201003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I sort and not lose reference to the cell? | Excel Discussion (Misc queries) | |||
| why do I lose cell format in a pivot table? | Excel Worksheet Functions | |||
| When using & and a date-formatted cell in a formula I lose the for | Excel Worksheet Functions | |||
| Refresh PivotTable, lose custom cell formatting | Excel Discussion (Misc queries) | |||
| lose formatting (border) in excel cell after pasting from word | Excel Discussion (Misc queries) | |||
Threaded Mode
