help with formula

[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

 

[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),"")