Need formula to sum data of each day of the year

[thanos_mes]

Hello im doing my desertation and im knd of stuck,

I have a table with data of each 365 days of the year kind like:

day data1 data2 data 3
1 54 48 65
1 45 50 66
1 43 51 67
2 45 55 65
. . . .
365 45 55 66

Now what i must do is to find how to get in a new columns the sums of each day's data.
so basicly i need the sum of data1 for each day of the year in a new column, the data2 of each day in another and the data3 of each day in another column..

 

[AlphaFrog]

Hi and welcome.

You can use the SUMIF function for this...

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	day	data1	data2	data3		Totals	data1	data2	data3
2	1	54	48	65		1	142	149	198
3	1	45	50	66		2	45	55	65
4	1	43	51	67
5	2	45	55	65		365	45	55	66
6
7	365	45	55	66
Sheet

 

[thanos_mes]

it sais the formula you typed contains an error... not only in my sheet but i made a sheet copy paste from your arrays and still didnt work.

 

[thanos_mes]

=SUMIF($A:$A,$F2,B:B)
its =SUMIF($A:$A;$F2;B:B) in office for mac. But i realy want to thank you from the bottom of my hurt

 

[AlphaFrog]

Video Tutorial
MrExcel's Learn Excel #827 - SUMIF