Re: Adding up ranges of numbers...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bernie Deitrick (_at_)
Date: 05/28/04 

Date: Fri, 28 May 2004 13:45:18 -0400

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

"CrazyTexan >" <<CrazyTexan.16yzqo@excelforum-nospam.com> wrote in message
news:CrazyTexan.16yzqo@excelforum-nospam.com...
> Help! :confused:
>
> I have a spreadsheet of numbers... sales figures for a number of
> stores.. with each row being a store, and each column being the sales
> for one day. So for each month, I end up with 31 columns of numbers in
> 10 rows (10 stores)
>
> 2 times a week, on tuesdays and fridays, I need to add up the month to
> date sales. This means from the 1st of the month to the first tuesday,
> first friday, second tuesday, second friday.. etc etc... The total
> number of days in this formula varies each month since the month starts
> of a different day each month, and makes updating the spreadsheets a
> pain since I have to add up several different sets of numbers in many
> locations each month.
>
> Is there any way to make this task fairly simple? I'd love something
> where I enter =SUM($B$1:D1) for the first day that I sum these numbers,
> and it automatically figures that the next day is 3 days later, and so
> adds the 3 cells for the next row.. and then repeats that for each day
> I need a total for.
>
> I think I've confused myself.. maybe someone else can make sense out of
> this? Please help! :)
>
> J. :confused: :rolleyes: :mad: :confused: :rolleyes: :mad:
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Adding up ranges of numbers...
    ... I have a spreadsheet of numbers... ... with each row being a store, and each column being the sales ... 10 rows (10 stores) ...
    (microsoft.public.excel)
  • Re: GW sales down
    ... hobby stores have thrived over the last 20 years or so on role play games, ... Role play games and movie merchandise are in decline; ... be bought in mass market outlets which hurts hobby store sales. ... Support promises by sales department that never materialize including: ...
    (rec.games.miniatures.warhammer)
  • Is The Recession Here? Americans Think So...
    ... Retailers had weak sales in December By ANNE D'INNOCENZIO, ... Stores Corp., as well as department stores including Macy's Inc. ... "Overall, the holiday season was dismal," said Ken Perkins, president ...
    (misc.survivalism)
  • Retailers Happy With Strong Holiday Start, Democrats Dismayed and Still Hate America
    ... NEW YORK -- The nation's shoppers _ setting aside worries about higher gas prices and a slumping housing market _ proved their resilience over the Thanksgiving weekend, giving what the nation's merchants wished for _ a strong start to the holiday shopping season. ... Stores and malls opened the season as early as midnight, drawing bigger-than-expected crowds Friday for discounted flat-panel TVs, digital cameras and toys such as all things related to Disney Channel's "Hannah Montana." ... Strong sales continued through Saturday, according to one research group that tracks total sales at retail outlets across the country. ...
    (alt.politics)
  • Re: Wal-Mart revisited
    ... # but a hell of a lot cheaper than the Range ... With regard to Wal*Mart and their sales practices, ... I can assure you that guns are not being ... the stores to keep or get rid of the guns. ...
    (rec.guns)