Adding up ranges of numbers...

[CrazyTexan]

Help!

I have a spreadsheet of numbers... sales figures for a number o
stores.. with each row being a store, and each column being the sale
for one day. So for each month, I end up with 31 columns of numbers i
10 rows (10 stores)

2 times a week, on tuesdays and fridays, I need to add up the month t
date sales. This means from the 1st of the month to the first tuesday
first friday, second tuesday, second friday.. etc etc... The tota
number of days in this formula varies each month since the month start
of a different day each month, and makes updating the spreadsheets
pain since I have to add up several different sets of numbers in man
locations each month.

Is there any way to make this task fairly simple? I'd love somethin
where I enter =SUM($B$11) for the first day that I sum these numbers
and it automatically figures that the next day is 3 days later, and s
adds the 3 cells for the next row.. and then repeats that for each da
I need a total for.

I think I've confused myself.. maybe someone else can make sense out o
this? Please help!

J. :mad

 

[Bernie Deitrick]

J,

Isn't "Crazy Texan" a redundant phrase? <vbg> (Note: I love Texas, and
Texans, having lived there for a couple of years....)

Let's say that you have dates in row 1, and your 31 columns of data are in
columns B to AF. If the data you want to sum is in row 2, then the formula

=SUMIF($B$1:$AF$1,"<=5/25/04",B2:AF2)

will sum the values up to May 25.

If you have days only, and not dates (1 to 31) then you can use

=SUMIF($B$1:$AF$1,"<=25",B2:AF2)

Either formula can be copied down.

If you want to simply put the desired date into a cell, then use the form:

=SUMIF($B$1:$AF$1,"<="&A1,B2:AF2)

where A1 has the date or day number.

HTH,
Bernie
MS Excel MVP