I have a spread sheet that has customer numbers and total product orders for each customer.
The sheet is a schedule that has customers reoccurring.
I want to be able to put in customer 222 and have excel find the last occurrence of that customer and sum up all the orders above that customer so that I may be able to quickly have time frames of completion.
The sheet would look something like what I have attached. Customer Orders.xlsx
Last edited by rdperry11; 02-23-2015 at 06:25 AM.
You can use this array* formula in H3:
=SUM(INDIRECT("C3:C"&MAX(IF(B$3:B$12=G3,ROW(B$3:B$12)))))
then copy down.
* NOTE: an array formula needs to be committed using the key combination of CTRL-SHIFT-ENTER (CSE), rather than the usual <Enter>.
Hope this helps.
Pete
H2=SUM($C$3:INDEX($C:$C,MAX(INDEX(($B$3:$B$12=$G3)*ROW($C$3:$C$12),0))))
Try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks