Currently Being ModeratedFeb 13, 2014 11:50 AM (in response to Yellowbox)
@ Barry: I was finally able to thoroughly go through your answer. I see how it is done.
Since each of my months are in different tables, I'll have to manually add month data to a summary table as you suggested. A little more work but it definitely provides the intended result.
Currently Being ModeratedFeb 13, 2014 1:35 PM (in response to 4thSpace)
It should be possible to collect the data onto the summary table using formulas without too much difficulty, provided each month table is laid out in the same manner as all the others. The formula would depend on the location of each day's data on its monthly table, and on the nme and location of each month's table.
Can you post screen shots of your January, February and April tables (or any other three that show the three possible month lengths), plus a list of the names of each monthly table.
Alternately, you could send me a copy of your Numbers file containing real or dummy data to work with. My eamil address is available in my profile—click my name above this message to get there.
Currently Being ModeratedFeb 17, 2014 6:21 AM (in response to Barry)
Here is a new discussion with the tables posted: https://discussions.apple.com/thread/5911103.
Currently Being ModeratedFeb 18, 2014 1:32 AM (in response to 4thSpace)
Thanks for the link. I've replied in the new thread.