sum if help when no data

[Imran Azam]

HI Guys

i currently have the below formula

=IFERROR(SUMIFS(data!R:R,data!O:O,"Alex",data!U:U,"Won",data!R:R,">0"),"-"))

if there is no data for Alex in the data sheet i want to retunr "-"

but with the formula i have it retuns 0.

how can i do this?

 

[theBardd]

There is no error, you just need to check the result

[LEFT][COLOR=#333333][FONT=Verdana]=IF(SUMIFS(data!R:R,data!O:O,"Alex",data!U:U,"Won",data!R:R,">0")>0,SUMIFS(data!R:R,data!O:O,"Alex",data!U:U,"Won",data!R:R,">0"),"-")[/FONT][/COLOR][/LEFT]

<strike></strike>

 

[Imran Azam]

thanks

 

[earwig999]

HI Guys

i currently have the below formula

=IFERROR(SUMIFS(data!R:R,data!O:O,"Alex",data!U:U,"Won",data!R:R,">0"),"-"))

if there is no data for Alex in the data sheet i want to retunr "-"

but with the formula i have it retuns 0.

how can i do this?

Currently you are only going to obtain " - " if there is an error.

Try this - =IF(data!O:O="Alex",SUMIFS(data!R:R,data!O:O,"Alex",data!U:U,"Won",data!R:R,">0"),"-")

** Edit ** Sorry I was replying went on to something else and didn't submit. Better late than never!

 

[theBardd]

Try this - =IF(data!O:O="Alex",SUMIFS(data!R:R,data!O:O,"Alex",data!U:U,"Won",data!R:R,">0"),"-")

This will always return a - unless the very first row contains Alex. Also, if row 1 contains Alex and U1 does not contain Won it will return 0 which I don't think is what the OP wants. So it is a false solution.

** Edit ** Sorry I was replying went on to something else and didn't submit. Better late than never!

Debatable