LinkBack URL
About LinkBacks
makinmomb 
Formula on f3 to pull right and down to work
Pull how much total quantity sold on those dates against row data which is on column ABC
Formula on f3 to pull right and down to work
Pull how much total quantity sold on those dates against row data which is on column ABC
In cell F3:
Formula:
=SUMIF($A$3:$A$631,F$2,$C$3:$C$631)
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
=sumifs($c$3:$c$631,$b$3:$b$631,$e3,$a$3:$a$631,f$2)
Ah, of course.That is perfect task for a pivot table.
Awesome John , Jacc yours did not work
John your formula should earn me something ,
I am doing analysis for a stationery shop to find the flow of common items
I know how pivots work , I needed a formula that did the work of pivot
Which I have now got
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks