Hey guys im stuck on an issue. Is there a way to sum across multiple sheet based on month and category?
In the sheet attached I have payments made in each month by category and want to sum on each debit. I fill out the first few.
Any assistance would be greatly appreciated.
Last edited by day92; 02-26-2014 at 03:59 PM.
Hi,
Not sure I understand. Since each of your tabs is a month in itself, and you are wanting sums for individual months, why would any of the sums be taken across multiple, different sheets?
Regards
Maybe I wasnt clear. Im trying to get them all on one sheet. Some months may be a zero.
What I did was take all the categories and delete the dups, now Im trying to sum them all up on one sheet.
Try this one
=SUMPRODUCT((Jan!$B$2:$B$70=A3)*(Jan!$F$2:$F$70))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Sh*t that was easy enough. Not sure why I didnt think of that.
Thanks!
You're welcome and thank you for your feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks