I want to get data for each month for different items and their total sales, so three arguments involved. I can get each item and total cost for all sales of that item, but not also for each month. have tried sumif/s/sumproducts. Maybe that's wrong! Can anyone help, please? Thank you in hope!
iMac
Hi Kari,
This community is for discussions involving the Mac application, Numbers, but I suspect the same formulas would apply in Excel in this case.
Can you provide a screen shot so we can see where to start, please. Show the cells holding the information to be referenced, and the cel where the result is to be shown.
Regards,
Barry
Morning Barry! this is really kind of you. screenshot with explanation attached.
If your goal is to have I3 sum everything that matches the "TYPE" and "DATE OF EXPENSE" of that row you can use a formula similar to =SUMIFS(F$3:F$9,C$3:C$9,C3,D$3:D$9,D3).
Hi karibou85,
I am really fond of index columns for situations like this. I set up a report table for the results.
formula in the index is filled down.
F2 =MONTH(C2)&B2
table 2 is my report. Months of the year in the header column, expense types in the header row.
B2 =SUMIF(Table 1::$F,MONTH($A2)&B$1,Table 1::$E)
This is filled down and across.
quinn
Hello everyone. Thank you so much for going to the trouble of helping, really kind. Both suggestions great but not quite there. I thought it might help to show you the screenshot of the other sheet where the monthly totals for each different item in 'Type' will go. You can also see my half successful formula, which did find the totals for different items (each formula had a different item in it) but the totals were not filtered by month. Hope that helps and thanks!
Hi kaz,
It takes very little effort to apply my solution to your table. Give it a try. Header row is formatted as Date/time.
quinn
need help creating a formula with three arguments in excel 2007 for mac
