How to find this total?
Cumbersome, but it works
=SUM(INDEX($B$1:$B$100,MATCH(C1,A:A,0)):INDEX($B$1 :$B$100,
IF(MIN(IF(INDEX($A$1:$A$100,MATCH(C1,A:A,0)+1):A10 0<"",ROW(INDIRECT(MATCH(C1,A:A,0)+1&":100"))))=0, 100,MIN(IF(INDEX($A$1:$A$100,MATCH(C1,A:A,0)+1):A1 00<"",ROW(INDIRECT(MATCH(C1,A:A,0)+1&":100"))))-1)))
as an array formula, commit with Ctrl-Shift-Enter, not just Enter
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"TimN" wrote in message
...
I have a spreadsheet set up as the following:
In Column A1 I have salesman names.
In Col B1 I have each individual unit sale with a sum at the bottom.
Example:
(A1) (B1) (C1) (D1)
Tim 45 Tim 65
10 Mary 7
8
2
Total 65
Mary 4
3
Total 7
How can I do a lookup that in say cell C1 gives me salesman name and in
cell
D1 gives me the total sales for that salesman? Each day new individual
sales
are added and perhaps a new salesman (salesperson)is added also.
Thanks!
|