| View previous topic :: View next topic |
| Author |
Message |
tanman
General User
Joined: 09 Sep 2011
Posts: 5
|
 Posted: Fri Sep 09, 2011 9:39 am Post subject: [SOLVED] HOW TO SUM BY DATE IN CALC |
 |
|
My problem is I have multiple values for days, I need them to be summed for each day. For instance, In column A I will have the dates they may be like 06/01/11, 06/01/11, 06/02/11, 06/02/11, and 06/03/2011, 06/03/2011, 06/03/2011. I will also have corresponding values with these dates in coumn B. I need to know how to sum the values for each day. I have tried sumif function, but I am not sure that I am doing it right. If anyone can help, I will greatly appreciate it.
Thanks,
Last edited by tanman on Sun Sep 11, 2011 9:31 am; edited 1 time in total |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
tanman
General User
Joined: 09 Sep 2011
Posts: 5
|
| Posted: Fri Sep 09, 2011 10:31 am Post subject: |
|
|
| Thanks, I will try that. I appreciate your response. |
|
| Back to top |
|
|
tanman
General User
Joined: 09 Sep 2011
Posts: 5
|
| Posted: Fri Sep 09, 2011 10:40 am Post subject: I dont think it is working |
|
|
I am trying this and it is not working. I am not getting the correct numbers
Do you know of another solution? |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Fri Sep 09, 2011 10:47 am Post subject: |
|
|
How can I know? You don't tell us anything.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
tanman
General User
Joined: 09 Sep 2011
Posts: 5
|
| Posted: Fri Sep 09, 2011 11:17 am Post subject: |
|
|
| Nevermind I was messing up, your solution works. Thank you I greatly appreciate it. |
|
| Back to top |
|
|
|
