good day all
PFA..in sheet named AUg 2016 plz use column E,F and H, want results in sheet 1 that column B (Approved By) Q'ty and Amount as per their heading
Gondal
good day all
PFA..in sheet named AUg 2016 plz use column E,F and H, want results in sheet 1 that column B (Approved By) Q'ty and Amount as per their heading
Gondal
I'm not clear what you meant by quantity, but I have assumed it is the number of lines that make the total
Quantity (in E3, copy & paste to other columns)
=COUNTIFS('Aug,2016'!$H:$H,Sheet1!$B3,'Aug,2016'!$E:$E,Sheet1!E$1)
Amount (in f3, copy & paste to other columns)
=SUMIFS('Aug,2016'!$F:$F,'Aug,2016'!$H:$H,Sheet1!$B3,'Aug,2016'!$E:$E,Sheet1!E$1)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
with a pivot table.
please reply.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
thanks Glenn Kennedy ..its working for me
thanks oeldere for new idea, pl help to guide how i can do it near future for others work sheet,
find on the internet a movie or book about pivot table.
it is a very powerfull tool which expands in every new version of excel.
i have a some idea of pivot table but not most advance, if you are referring me some new version or tool regarding this than pl share some link..?? or this is all under pivot table just i need find the idea..?
Gondal
Correct, this is all under pivot table.Please Login or Register to view this content.
But as already added MS expand the tools of the pivot table in each new version of excel.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks