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 ?
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 ?