Less than and Greater than and return total

[juca73]

Hi All,

I have the following formula

=SUMIFS(Data!$AG$7:$AG$1048576,Data!$D$7:$D$1048576,$F$8,Data!$P$7:$P$1048576,">=3.00",Data!$P$7:$P$1048576,"<=3.50",Data!$M$7:$M$1048576,$G$7,Data!$N$7:$N$1048576,$J$7)

and what i have to do at the moment is replace the >= & <= values manually, what i want to do is use the cells the figures are in but when i do that i just get a return value of 0.

The >= & <= values are in the results table NOT the main data table.

Can any one help ?

 

[etaf]

not sure I understand
Do you have 2 cells that have the values 3.0 and 3.5 , that may change
then
">="& CELL with 3.0 in
"<="& Cell with 3.5 in

NOT sure why you have to replace the <= & >= , unless. different formula

Assuming 3.0,& 3.5 is in the results table cell A2 and B2

=SUMIFS(Data!$AG$7:$AG$1048576,Data!$D$7:$D$1048576,$F$8,Data!$P$7:$P$1048576,">="&results!$A$2,Data!$P$7:$P$1048576,"<="&results!$B$2,Data!$M$7:$M$1048576,$G$7,Data!$N$7:$N$1048576,$J$7)

 

[dk]

Hi,

In your example, are the values 3.00 and 3.50 in a particular cell? If the values were in cell A1 and A2 for example then does this work?

=SUMIFS(Data!$AG$7:$AG$1048576,Data!$D$7:$D$1048576,$F$8,Data!$P$7:$P$1048576,">="&A1,Data!$P$7:$P$1048576,"<="&A2,Data!$M$7:$M$1048576,$G$7,Data!$N$7:$N$1048576,$J$7)

I tried a simpler example and seemed to work ok for me.

 

[juca73]

Hi,

In your example, are the values 3.00 and 3.50 in a particular cell? If the values were in cell A1 and A2 for example then does this work?

=SUMIFS(Data!$AG$7:$AG$1048576,Data!$D$7:$D$1048576,$F$8,Data!$P$7:$P$1048576,">="&A1,Data!$P$7:$P$1048576,"<="&A2,Data!$M$7:$M$1048576,$G$7,Data!$N$7:$N$1048576,$J$7)

I tried a simpler example and seemed to work ok for me.

dk

That works perfectly, thankyou, made my life a bit easier