Totalising Daily Values

[ghew]

Hi Everyone,
Its been a very long time since using excel for any real work but I need some help. I need to totalise records for each day, I have tried some conditional statements but cant for the life of me remember the correct way to do it:


Column A has date stamps 11/5/2011 12/5/2011,13/5/2011 etc
Column B has half hour timestamps eg: 6:30, 7:00,7:30 etc
Column C has the data I need totalised

I was thinking a SUMIF statement to sum the data if we are still in the same day from column A but I am struggling to get it working.
Any help would be greatly appreciated

Cheers.

 

[T. Valko]

Hi Everyone,
Its been a very long time since using excel for any real work but I need some help. I need to totalise records for each day, I have tried some conditional statements but cant for the life of me remember the correct way to do it:


Column A has date stamps 11/5/2011 12/5/2011,13/5/2011 etc
Column B has half hour timestamps eg: 6:30, 7:00,7:30 etc
Column C has the data I need totalised

I was thinking a SUMIF statement to sum the data if we are still in the same day from column A but I am struggling to get it working.
Any help would be greatly appreciated

Cheers.

Maybe this...

E1 = the date to sum for like 11/5/2011

=SUMIF(A:A,E1,C:C)

 

[CWatts]

Perhaps something like this?

=SUMIF(A:A,A1,C:C)

 

[ghew]

Thanks for that guys,
Maybe my examples weren't very good (tried yours and didnt work)

A B C
1/2/2011 0:00:00 5
1/2/2011 0:30:00 8
1/2/2011 1:00:00 3
1/2/2011 1:30:00 5
1/2/2011 2:00:00 6
1/2/2011 2:30:00 3
1/2/2011 3:00:00 2
1/2/2011 3:30:00 9
1/2/2011 4:00:00 11
1/2/2011 4:30:00 17
1/2/2011 5:00:00 13
.....
1/2/2011 23:30:00 22
2/2/2011 0:00:00 5
etc.

So what I need to do is calculate the total for each day in column C
Cheers.

 

[ghew]

sorry about the formatting, A = datestamp B = timestamp C = Data

 

[T. Valko]

Thanks for that guys,
Maybe my examples weren't very good (tried yours and didnt work)

A B C
1/2/2011 0:00:00 5
1/2/2011 0:30:00 8
1/2/2011 1:00:00 3
1/2/2011 1:30:00 5
1/2/2011 2:00:00 6
1/2/2011 2:30:00 3
1/2/2011 3:00:00 2
1/2/2011 3:30:00 9
1/2/2011 4:00:00 11
1/2/2011 4:30:00 17
1/2/2011 5:00:00 13
.....
1/2/2011 23:30:00 22
2/2/2011 0:00:00 5
etc.

So what I need to do is calculate the total for each day in column C
Cheers.

Can you be more specific about the "didn't work" bit?

Did you get an incorrect result? No result? an error? ???