SUMIF multiple criteria

[OfficeGirlKE]

I'm running numbers for the company, making per week totals for business
written. My problem is that I need to pull the data from a different
sheet('[MasterNewBusiness.xls]2004JulyDec'), specific range ($G$58:$G$122),
criteria ("'08/22/2004"), add the numbers from a different
column($H$58:$H$122)... and I need to have a sum total for the seven days,
which equals seven different criteria.

What I'm doing is
=SUMIF('[MasterNewBusiness.xls2004]JulyDec'$G$58:$G$122,"'08/22/2004",'[MasterNewBusiness.xls]2004JulyDec'!$H$58:$H$122)+SUMIF('[MasterNewBusiness.xls]2004JulyDec'!$G$58:$G$122,"08/23/2004",'[MasterNewBusiness.xls]2004JulyDec'!$H$58:$H$122)+SUMIF...etc

Now, this works. But I need to do this for an entire year of business.
Looking for a way to condense the criteria so I don't have to have the entire
formula seven times for each cell. Any ideas?

 

[Paul Corrado]

Give this a try

=SUMIF('[MasterNewBusiness.xls2004]JulyDec'$G$58:$G$122,","<=8/22/04",'[Mast
erNewBusiness.xls]2004JulyDec'!$H$58:$H$122)

 

[Myrna Larson]

If your dates are stored as true Excel dates (not text) and you are talking
about consecutive dates, you can do it with just 2 SUMIF formulas. The first
gets the total for all dates greater than or equal to the earlier date, the
2nd SUMIF get the total for dates greater than the later date, then you
subtract, like this:

=SUMIF(Sheet1!$G$58:$G$122,">=08/22/2004",Sheet1!$H$58:$H$122)
-SUMIF(Sheet1!$G$58:$G$122,">=08/29/2004",Sheet1!$H$58:$H$122)

If you have the week starting dates in some cells, say A1 and A2, you can
write the criteria as ">="&A1 for the first and ">="&A2 for the second. You
need the quotes.