Hi,

I have this formula but since 0 is a number and not an error it is returning 0's instead of my error furmula. What would be the best way to go about fixing this?

=IFERROR(SUMIFS(Billed!$D:$D,Billed!$A:$A,F72,Billed!$B:$B,$B72),IF(F74="Internal",(F76/(1+15%)),(F76/(1+F73+6%))))