add an "iserror" to an exsiting formula

Hi All,

I can't add an "iserror" to this formula, =IF((AND(G$5>=$B7,G$5<=$C7,$D7="weekly")),$E7,"")

I need to remove the error messages so I can add up the column.

Any help would be much appreciated,

Thank you

If you are using XL2010 you can use the IFERROR function, like this:

=IFERROR(IF((AND(G$5>=$B7,G$5<=$C7,$D7="weekly")),$E7,""),0)

You can change the 0 at the end to something else if you wish.

Hope this helps.

Pete

Thank you Pete,

It worked.