SUMIF Cell Reference as Criteria

[JEN_P]

Hello -
I want to do a sumif where the criteria is Less than or
equal to cell E61. I have the below formula working, but
it only sums the cells that are EQUAL to E61. I can't
figure out how to word it so it sums all cells <= E61.

=((SUMIF('[2004 Press Runs.xls]AA'!$A$2:$A$53,E61,'[2004
Press Runs.xls]AA'!$D$2:$D$53)))

Thank you!
Jenni

 

[Andy B]

Hi

Try this:
=((SUMIF('[2004 Press Runs.xls]AA'!$A$2:$A$53,"<="&E61,'[2004 Press
Runs.xls]AA'!$D$2:$D$53)))

 

[keepITcool]

=SUMIF('[2004 Press Runs.xls]AA'!$A$2:$A$53,"<="&E61,'[2004

Press Runs.xls]AA'!$D$2:$D$53)

removed the outer braces.. they serve no purpose


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

Hello -
I want to do a sumif where the criteria is Less than or
equal to cell E61. I have the below formula working, but
it only sums the cells that are EQUAL to E61. I can't
figure out how to word it so it sums all cells <= E61.

=((SUMIF('[2004 Press Runs.xls]AA'!$A$2:$A$53,E61,'[2004
Press Runs.xls]AA'!$D$2:$D$53)))

Thank you!
Jenni

 

[Jen_p]

Worked like a charm!
THANKS!

-----Original Message-----
Hi

Try this:
=((SUMIF('[2004 Press Runs.xls]AA'!

$A$2:$A$53,"<="&E61,'[2004 Press

Runs.xls]AA'!$D$2:$D$53)))

--
Andy.

Hello -
I want to do a sumif where the criteria is Less than or
equal to cell E61. I have the below formula working, but
it only sums the cells that are EQUAL to E61. I can't
figure out how to word it so it sums all cells <= E61.

=((SUMIF('[2004 Press Runs.xls]AA'! $A$2:$A$53,E61,'[2004
Press Runs.xls]AA'!$D$2:$D$53)))

Thank you!
Jenni

.

 

[Andy B]

Thanks for the thanks!

--
Andy.

Worked like a charm!
THANKS!

-----Original Message-----
Hi

Try this:
=((SUMIF('[2004 Press Runs.xls]AA'!

$A$2:$A$53,"<="&E61,'[2004 Press

Runs.xls]AA'!$D$2:$D$53)))

--
Andy.

Hello -
I want to do a sumif where the criteria is Less than or
equal to cell E61. I have the below formula working, but
it only sums the cells that are EQUAL to E61. I can't
figure out how to word it so it sums all cells <= E61.

=((SUMIF('[2004 Press Runs.xls]AA'! $A$2:$A$53,E61,'[2004
Press Runs.xls]AA'!$D$2:$D$53)))

Thank you!
Jenni

.