summing certain dates

  • Thread starter Thread starter SOPH
  • Start date Start date
S

SOPH

Hi again
I have a sheet set up so that the top row has the dates
throughout 1 month and the left most column has timesteps
in 15 min intervals from midnight to 23:45. for each
interval per date there is an integer value. What I need
to do is have a column set up on the right side summing
the data for each day of the week per interval, however I
am not sure how to sum only certain cells. Do I need to
do some sort of match/index function?
Thanks heaps
Soph
 
Hi,

Your data will be in B2:AF97 (31 columns by 96 rows)

In AH1:AN2 put the numbers 1 to 7
In AH2 : =SUMPRODUCT((WEEKDAY($B$1:$AF$1)=AH$1)*$B2:$AF2)

Copy AH2 to AH2:AN97

Regards,

Daniel M.
 
Back
Top