IFERROR formula

[Legacy 452653]

Hi,

Im working on a warehouse database with orders and quotes I have this IF formula =IF($B2="","",SUMIF(CheckOrderCommitted,B2, CommittedQuote)) But its giving me a $REF in all cells.

This is because the cells reference too, Data is not in the cell., Im trying to do a IFERROR so that when there is no data it should represent "0"

I have tried =IFERROR($B2="","",SUMIF(CheckOrderCommitted,B2, CommittedQuote),"") & =IFERROR($B2="","",SUMIF(CheckOrderCommitted,B2, CommittedQuote),"0")) and still does not work

Can you help me on this iferror formula

Thanks

Steve

 

[fhqwgads]

maybe
=IFERROR(IF($B2="","",SUMIF(CheckOrderCommitted,B2, CommittedQuote)), 0)
if a formula is giving you an error and you want to IFERROR it, use the formula as it is. you shouldn't have removed the IF in IF($B2="","",SUMIF(CheckOrderCommitted,B2, CommittedQuote))
=IFERROR(your formula that's giving the error, 0)

 

[Peter_SSs]

This is because the cells reference too, Data is not in the cell.,

I don't understand that, but it sounds like one or both of your named ranges does not exist.
If you go to the Formulas ribbon tab and then Name Manager, what do you see in relation to the names CheckOrderCommitted and CommittedQuote

In the interim, unless B2 contains a formula that could return an error, you should only need the IFERROR on the SUMIF part of your formula.
And don't put quotes around the zero.

=IF($B2="","",IFERROR(SUMIF(CheckOrderCommitted,B2, CommittedQuote),0))

 

[Legacy 452653]

Bang on the money.

Unbelievable thanks for this. The thing works!

Legend!

 

[Legacy 452653]

From the previous reply
=IFERROR(IF($B2="","",SUMIF(CheckOrderCommitted,B2, CommittedQuote)), 0)

Works to a T !

But thanks anyhow

Steve

 

[Peter_SSs]

Glad you got a successful outcome. Thanks for letting us know.

 

[Legacy 452653]

Interestingly, that formula work as well so how about that!

 

[Peter_SSs]

For the future, it would help your helpers if you clarified what you were referring to with your comments. For example, we have no idea what the following are referring to.

Bang on the money.

Interestingly, that formula work as well so how about that!