Currently Being ModeratedJan 16, 2013 10:30 AM (in response to smash09)
Here's an example of what can be done:
The formula in the Total column of Summary is:
=SUMIFS(Log :: B, Log :: A, ">="&A, Log :: A, "<"&EOMONTH(A, 0)+1)
The Month column of Summary is filled with a series of dates that can be formatted as Jan-13, etc, if you wish.
I used the 0h 0m format for the Durations to distinguish it from times.
Currently Being ModeratedJan 16, 2013 11:15 AM (in response to Jerrold Green1)
All you wrote makes sense yet the value returned is always zero. I did verified the cell format for "duration" and the hr:mm format.
I can get the following format to work though:
=SUMIFS($Log B,Log A,">=01/01/2013",Log A,"<=01/31/2013")
Currently Being ModeratedJan 16, 2013 12:58 PM (in response to smash09)
What that tells me is that your Column A entries were not interpreted as Date Values in the summary table. A way to test this is to try a different format on that column. If you can change the format, you are working with date values. If not, the dates are being interpreted as text.