help with formula

O

ofaolain

hi can someone point me in the right direction
the below formuls keeps coming up with errors

=IF(E3=$P$1,if(ISERROR((SUM(H3),0,((SUM(H3)),"")



Cheers

Andy
 
M

mbarron

You have too many ( )s in your formula. You also don't need to use
the SUM function on a single cell.

Your formual can be simplified to:
=IF(E3=$P$1,IF(ISERROR(H3),0,H3),"")
 
Top