[help] how to sum up values for every day/week/weekday

My chart contains basicly 6 months of data with multiple entries per day. every entry already includes the respective date and weekday

I would like to know if its possible to sum up and output the results for each individual day and or week and or for all mondays, tuesdays (and so on) combined

doing that manually would be alot of time.

thanks for the help.

Assume your dates are in column A, with values to be added in column B. If you list all the individual dates in column D (put the first date in D1 and then this formula in D2, copied down:

=D1+1

then you can have this formula in E1:

=SUMIF(A:A,D1,B:B)

and then copy this down.

Put the start date of the first week in G1 and this formula in G2:

=G1+7

and copy this down to get weekly dates, then you can have this formula in H1:

=SUMIFS(B:B,A:A,">="&G1,A:A,"<"&G1+7)

and copy this down. Finally, put the names of the days of the week in J1 down, and this formula in K1:

=SUMPRODUCT(--(TEXT(A$1:A$500,"dddd")=J1),B$1:B$500)

Adjust the ranges to suit, then copy down.

Hope this helps.

Pete

thanks, worked wonderful