Sumifs - indirect

[Jazzer]

Excel 2007

Hi,

I am using the following SUMIFS

=SUMIFS('NOMAD DATA'!I11:I390,'NOMAD DATA'!E11:E390,"<="&D10,'NOMAD DATA'!F11:F390,">"&D10)

The Data in my Nomad Data tab is deleted and replaced via a macro - this then gives the following error to my formula

=SUMIFS(NOMADDATA!#REF!,NOMADDATA!#REF!,"<="&D10,NOMADDATA!#REF!,">"&D10)

Is it possible to use the INDIRECT function in my formula to stop this happening?

Thanks
James

 

[NBVC]

Try

=SUMIFS(INDIRECT("'NOMAD DATA'!I11:I390"),INDIRECT("'NOMAD DATA'!E11:E390"),"<="&D10,INDIRECT("'NOMAD DATA'!F11:F390"),">"&D10)

 

[T. Valko]

Excel 2007

Hi,

I am using the following SUMIFS

=SUMIFS('NOMAD DATA'!I11:I390,'NOMAD DATA'!E11:E390,"<="&D10,'NOMAD DATA'!F11:F390,">"&D10)

The Data in my Nomad Data tab is deleted and replaced via a macro - this then gives the following error to my formula

=SUMIFS(NOMADDATA!#REF!,NOMADDATA!#REF!,"<="&D10,NOMADDATA!#REF!,">"&D10)

Is it possible to use the INDIRECT function in my formula to stop this happening?

Thanks
James

see your other thread

 

[Jazzer]

Try

=SUMIFS(INDIRECT("'NOMAD DATA'!I11:I390"),INDIRECT("'NOMAD DATA'!E11:E390"),"<="&D10,INDIRECT("'NOMAD DATA'!F11:F390"),">"&D10)

That's great - thanks