I just figured it out - I did an array
=if(sum(if(a1:a20="N/A",1,0)0,"Error",sum(a1:a20))
Thanks!!

"Sean Timmons" wrote:

=if(isna(range of cells),Error,sum(range))

"ynissel" wrote:

I have a bunch of if formulas in a column that read if the condition is true
then .25 if its false then "n/a".
Is there a way for me to enter in a formula at the end of this column that
reads all these formulas and says if any of them is "N/A" then "Error" if not
sum them all up?
Thanks!