Hi all!
I need some help working out this formula. I'm pretty 'new' when it comes to Excel. I know basic formulas and stuff so I'm sorry if this seems like a noob question! But we all start somewhere.. right?
So I'm basically doing a spreadsheet for my boss of the number of outgoing calls each sales rep makes in a month and then working out the average calls per day, however when writing the formula, I need it to ignore text in the cells.
For example, cells C7, E7, G7, I7 and K7 I need to add up, and they are all number cells where we input the amount of calls the rep has made that day. However, when a rep is off sick/on annual leave/at a trade show, we want to be able to put that in the cell. So far I have:
=IF(ISERROR(SUM(C7+E7+G7+I7+K7)),"",SUM(C7+E7+G7+I7+K7))
I used iserror because I want the cell to show blank if there are not enough values to complete the formula yet (we haven't got far enough in the month for it to calculate yet)
The formula works fine if the ref cells are blank or numbered cells but as soon as I write "SHOW" or "SICK" in the box, the formula breaks and the total box is blank again.
Again, sorry if this is a noob question, I'm stuck!
Thanks a lot for any help you can give.
- Skye x
Bookmarks