Help with a SUM IFS / INDEX MATCH function please
Hi,
I require some help - I am trying to find out the sum of a customer's total spend by month.
At the moment I have a breakdown of a customer's spend by product - but I want the sum of the spend on these products per month.
Please see example attached.
I think I may need a SUM with an Index Match function.
Any help would be great!
Thanks
welcome to the forum, Faizahchowdry. try:
=SUMIFS('current data format'!$D:$D,'current data format'!$A:$A,$A2,'current data format'!$C:$C,B$1)
copy down and across
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
You should use belowoneOriginally Posted by Faizahchowdry
Formula:
Please Login or Register to view this content.
I will take care about your month wise requirement.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi, I have tried this method but it is extremely slow as I have about 100,000 cells that need calculating - is there another quicker method?
I would prefer then Pivot table.
Select the data and press Alt->N-V and then enter. Now drag the field in respective areas as per your need.
Check the attached file.
Hope this will help/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks