Hi all,
I have a spreadsheet set up as follows:
Column A = dates in month/day/year format
Column E = number of hours
Column F = $ rate associated with the hours in Column E
Column I = Total of Column E X Column F
In Column J I would like to do the following, but I'm not sure what's
the most efficient way of doing it. I would like to summarize the
Total amount in Column I for each month and year. For example, I would
like to add the totals from Column I for all the data for the month of
May, 2004 (dates in Column A). I understand I can add a row under
each each month and subtotal the months that way, but I would prefer to
do this seperate from the original data in Columns A-I.
Is this possible?
Thanks!
--
hoosonfirst
------------------------------------------------------------------------
hoosonfirst's Profile:
http://www.excelforum.com/member.php...o&userid=26456
View this thread:
http://www.excelforum.com/showthread...hreadid=397251