mdg1
asked on
excel summing columns where with certain criteria
I have an excel spreadsheet that reflects expenses over a three year period - each row is another specific expense. For each expense, i have added a column with the week number that the date falls in ( a little problem may be that since there is more than one year, we have the same week number for different years - ie 1/1/2012 is week 1 and 1/1/2013 is week 1).
See attached spreadsheet for an example
So, i want to to create a summing formula so that I can add up all expenses of a particular expense (in this case "child care expense") that fall for each week number and to place the sum in the last row of each week
ee-totalling-per-week-number.xlsx
See attached spreadsheet for an example
So, i want to to create a summing formula so that I can add up all expenses of a particular expense (in this case "child care expense") that fall for each week number and to place the sum in the last row of each week
ee-totalling-per-week-number.xlsx
You could do it by manually entering each Childcare instance: =sum(G2,G13)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How about using Pivot Table?
This will summarise and group as required.
See attached.
Thanks
Rob H
Copy-of-ee-totalling-per-week-nu.xlsx
This will summarise and group as required.
See attached.
Thanks
Rob H
Copy-of-ee-totalling-per-week-nu.xlsx
ASKER
Thanks - that worked!