Total of Multiple Entries Per Day

[NoDayButToday]

I have a daily food log that shows calories consumed by meal for each day of a 2 year period, but the log doesn't have the total number of calories per day. I'd like to calculate the total number of calories for each specific day during that 2 year period. And, ultimately, I want to determine the average number of calories per day for that same time period.

 

[etaf]

toi get a unique set of dates - as 2019 does not have UNIQUE() according to MS reference site
then use

=IFERROR(INDEX($A$2:$A$29, MATCH(0, COUNTIF($D1:D$1, $A$2:$A$29), 0)),"")
and then
=SUMIF($A$2:$A$6,$D2,$B$2:$B$6)

=IFERROR(AVERAGEIF($A$2:$A$17,D2,$B$2:$B$17),"")

if that works, use the exact range to avoid the zero - and can be cleaned up a bit

looks like its a TABLE

Book1
	A	B	C	D	E	F
1				DATES	SUM	AVERAGE
2	1/1/15	1		1/1/15	15	5
3	1/1/15	2		2/2/15	33	16.5
4	1/1/15	12		1/0/00	0
5	2/2/15	14			0
6	2/2/15	19			0
7					0
8					0
9					0
10					0
11
Sheet1

Cell Formulas
Range	Formula
E2:E10	E2	=SUMIF($A$2:$A$6,$D2,$B$2:$B$6)
F2:F10	F2	=IFERROR(AVERAGEIF($A$2:$A$17,D2,$B$2:$B$17),"")
D2	D2	=IFERROR(INDEX($A$2:$A$29, MATCH(0, COUNTIF($D1:D$1, $A$2:$A$29), 0)),"")
D3:D11	D3	=IFERROR(INDEX($A$2:$A$29, MATCH(0, COUNTIF($D$1:D2, $A$2:$A$29), 0)),"")

 

[NoDayButToday]

Thank you! I was on the right track, but the IFERROR/INDEX formula you had in D2 was where I was messing up. Once I typed your formula in, it all came together.

 

[etaf]

you are welcome