Help, am I missing a bracket?

Hi,

=SUM(OFFSET(ADDRESS(6,MATCH($B$3,'Master Budget'!$3:$3,0)),MATCH(AF$5&$A11&$B11,'Master Budget'!$F$6:$F$64,0)-1,0,0,MONTH($B$3)-1))

This formula keeps coming up with one of those box errors so I am most likely missing a bracket or something.

I seem to have narrowed it down to the "ADDRESS" section.

If I take the Address portion out and just put in a random reference like B6, it works. But I cann't for the life of me figure out what I am missing from the Address function, I seem to already have all the necessary brackets.

Can someone please take a look?

Thanks

A common mistake offset(cell,rows, cols, height, width) If you have a height, you have to have a width and visa versa
=SUM(OFFSET(ADDRESS(6,MATCH($B$3,'Master Budget'!$3:$3,0)),MATCH(AF$5&$A11&$B11,'Master Budget'!$F$6:$F$64,0)-1,0,0,MONTH($B$3)-1))


you are missing a height?, perhaps 1? I've done it many times myself

Hi davesth,

I do have the width there, it is the last criteria.

I have jsut figured out what the issue is. The "Address" function returns a cell reference but in TEXT format. I therefore have the convert it into a reference by using Indirect function.

So the formula now works, but it is giving me an #na, so at least that's better, jut need to figure what's wrong with the formula now :P

Thanks,

Ah yes of course! That was a rookie error, thank you!