Another #DIV/0 Question.

[Aussie1]

I am using this formula to sum up Parts of my sheet.

=SUMIF('Current Inventory'!$B:$B,$B36,'Current Inventory'!$G:$G)+SUMIF('Current Inventory'!$B:$B,$C36,'Current Inventory'!$G:$G)+SUMIF('Current Inventory'!$B:$B,$E36,'Current Inventory'!$G:$G)+SUMIF('Current Inventory'!$B:$B,$D36,'Current Inventory'!$G:$G)/(7000/G36)

The part of the line gives the #DIV/0 error. I have tried few things but it is not working. Any help would be appreciated.

Dave

[Jonmo1]

Solving Div/0 is really easy (particularly in XL2007+ with the IFERROR function)

=IFERROR(your_formula_goes_here, "what you want instead of the error goes here")


But looking at your formula, it might not be doing what you think it's doing.

Do you want:
A) To get the result of the 4 sumifs added together, THEN devide by (7000/G36)
Or
B) Take the result of only the 4th sumif, devide that by (7000/G36) THEN add the other 3 sumifs


Your formula actually does B

[Aussie1]

Jonmo1,

Thank you much for the reply.

I am wanting it to do method B for sure.

Dave

[Jonmo1]

Great, glad to help.

[Aussie1]

I have tried this...=IFFERROR(SUMIF('Current Inventory'!$B:$B,$B36,'Current Inventory'!$G:$G)+SUMIF('Current Inventory'!$B:$B,$C36,'Current Inventory'!$G:$G)+SUMIF('Current Inventory'!$B:$B,$E36,'Current Inventory'!$G:$G)+SUMIF('Current Inventory'!$B:$B,$D36,'Current Inventory'!$G:$G)/(7000/G36),"Test")

And now I get #NAME?

[Jonmo1]

There's only 1 F in IFERROR

[martindwilson]

IFFERROR should be IFerror

[Aussie1]

Derp.... Got it!!