M

#### Mayur

have data. This formula calulates data by month. My spreadsheet has data in

there for Jan and the data calculates fine. But when I drag it to the other

eleven months it gives me this error which i can't have because i print it

out and post it. I need it to be blank. I have two formulas one that

calculates multiple rows wich is this one below:

=IF(ISERROR(VLOOKUP($B$3&$A24,Data!$B$2:$M$7246,6,FALSE)),"",VLOOKUP($B$3&$A24,Data!$B$2:$M$7246,6,FALSE))+(IF(ISERROR(VLOOKUP($B$4&$A24,Data!$B$2:$M$7246,6,FALSE)),"",VLOOKUP($B$4&$A24,Data!$B$2:$M$7246,6,FALSE)))+(IF(ISERROR(VLOOKUP($B$5&$A24,Data!$B$2:$M$7246,6,FALSE)),"",VLOOKUP($B$5&$A24,Data!$B$2:$M$7246,6,FALSE)))

Than I have this formulas that only calulates one row and doesn't show the

error in other rows:

=IF(ISERROR(VLOOKUP($B$3&$A22,Data!$B$2:$M$7246,6,FALSE)),"",VLOOKUP($B$3&$A22,Data!$B$2:$M$7246,6,FALSE))

But I need to use the first one. SO I NEED HELP WITH HOW TO MAKE THE ERROR

GO AWAY AND STILL CALCULATE BY MONTH.

This is so simple but I can't figure it out!!!!! PLEASE HELP!!!