Need help for result = "ERROR" with SUMIF Formula

[tuongtu3]

Hello All,
I'm trying to use the formula SUMIF but need result = "ERROR" if there's any criteria value = 0. Please see sample in attached and help me.

Regards,
tt3

[adhawan06]

Hi there,

Please refer the attach XLS file. It will give you "ERROR" to be display if you have "0.00" in column C again.


Let me know if this is the same you were looking for

[NeedForExcel]

Here!

=IF(ISNUMBER(SUMPRODUCT(MATCH(10,(A1:A17&C1:C17)+0,0))),"ERROR",SUMIF(A:A,1,C:C))

[:) Sixthsense :)]

In F1 Cell


=IF(COUNTIFS(A:A,ROWS($1:1),C:C,0),"Error",SUMIF(A:A,ROWS($1:1),C:C))


Drag it down..

[tuongtu3]

Hello All,

@adhawan06: work fine
@ Sixthsense : work fine
@NeedForExcel: not sure why it doesn't work (all result = "ERROR")


Regards,
tt3

[adhawan06]

Glad it worked and thanks for adding the feedback.


Now, please take few seconds to mark this thread as SOLVED.

[NeedForExcel]

Hello All,

@adhawan06: work fine
@ Sixthsense : work fine
@NeedForExcel: not sure why it doesn't work (all result = "ERROR")


Regards,
tt3

Works at my end.. :O But now that you have a few solutions, I guess it not required..