I am trying to return a value based on three different lookups. Date, Campaign and Transaction Type. I would like to return the quantity of items transacted on by day, campaign and transaction type. For other reasons, I do not want to use a pivot table to group the transaction types... I think its a vlookup, or combination of if/ find/ offset formula, but I really don't know. Any help would be greatly appreciated.
Try in L3:
=SUMIFS($G$3:$G$29,$B$3:$B$29,$J3,$C$3:$C$29,$K3,$E$3:$E$29,L$2)
copied down and across the matrix
and in P3:
=SUMIFS($F$3:$F$29,$B$3:$B$29,$J3,$C$3:$C$29,$K3)
copied down
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Ok, that was way too fast. Thank you!!!
have a look at countifs and sumifs
yep so fast i was late!
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Ok this is so great. I will be back. Unfortunately Pivot tables have made me lazy over the years.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks