Calculating Total Amounts per day

**IvoH** · 08-30-2011, 02:05 PM

Hi all,

I have A1 dates and B1 amounts. I want in column C, to calculate the totals from B1:B20 for that day.

Ex. if I have A1:A3 5/3 , in C3 to calculate the totals of B1:B3

I have attached an example.

I am pretty sure needs to be done with =sumproduct, but I cannot get it to work.

**zbor** · 08-30-2011, 02:12 PM

If you want next to first day: =IF(COUNTIF($A$1:A1,A1)=1,SUMIF($A$1:$A$10000,A1),"")

if you want next to last day: =IF(COUNTIF($A$1:A1,A1)=COUNTIF($A$1:$A$10000,A1),SUMIF($A$1:$A$10000,A1),"")

Also, next time please upload example WORKBOOK not a picture. Ty

**IvoH** · 09-03-2011, 02:29 PM

I cannot get the formula to work. The countif does not accept the criteria of A1,A1.

Also, notice that the date has time as well, but I need to calculate the rows that have the same date, but they want have the same value, because the time will be different.

Thank you.

I attached a workbook