Ignoring blank cell in complex Sum formula

[brfunk15]

Creating a title for this was tricky. So I have a spreadsheet in Google Sheets where I have three sets of data that I need to add together but there are times one or two of the cells might be blank. Basically, I am trying to create a Score for a call center rep where a call is worth 8 points, chats are worth 5 and a ticket is worth 7 points.

My sheet will pull how many calls, chats, ticket the rep did and then I need to add the point value and then add the three sets of data together to get the overall Score.

Calls are in B4, Chats in C4 and Tickets in D4 with the total cell in E4. =sum((B4*8)+(C4*5)+(D4*7)) works if all cells have data in it, there is a formula in each cell pulling the data from another tab with an iferror formula to show a blank cell if no data was found. How do I get the formula to treat cells that are blank as a 0 so that I will get a result and not an error?

 

[Special-K99]

What's the "formula in each cell" ?

Make sure that the "formula in each cell" returns a null "", NOT an actual space " ".
See if that amendment corrects your SUM formula.

 

[arthurbr]

AFAIK an empty cell multiplied by something returns 0 in Excel. Don't know about Google sheets though

 

[S_Wish]

[FONT=&quot]You can check whether it is number like:
if(ISNUMBER(B4);B4*8;0)[/FONT]

 

[brfunk15]

OMG This was it the whole time! I had an iferror formula that was resulting in a space and not a null value. Thank you so much! I'm so flustered that I worked on this all day for the issue to be with the original formula but I am glad its fixed!

 

[brfunk15]

Special-K99 solved this issue!! Thank you everyone for the input.