S
samilator
Arvi I’m having trouble following your suggestion. I’m also havin
trouble making my questions but I think I’ve finally got it right.
Let me rephrase my question:
I’ve got two sheets. Sheet1 = sell. Sheet2 = sell history.
Sheet1:
Column a = date
Column b = customer
Column c = branch
Column d = total ordered
Column e = stock no.
Column f = size
Sheet2:
Column a3:a5000 = stock nos.
Column b3:b5000 = sizes
Row C1:Z1 = customer
Row C2:Z2 = branch
Now C3 would should display the corresponding total ordered for th
intersecting conditions… as should the other cells
This is the formula I used for C3
SUMPRODUCT(--(Sheet1!B2:B5000=Sheet2!C1),--(Sheet1!C2:C5000=Sheet2!C2),--(Sheet1!E2:E5000=Sheet2!A3),--(Sheet1!F2:F5000=Sheet2!B3),Sheet1!D25000)
It works fine but when you’ve got too many of them excel freezes.
Is there another way around this?
Thanks again
trouble making my questions but I think I’ve finally got it right.
Let me rephrase my question:
I’ve got two sheets. Sheet1 = sell. Sheet2 = sell history.
Sheet1:
Column a = date
Column b = customer
Column c = branch
Column d = total ordered
Column e = stock no.
Column f = size
Sheet2:
Column a3:a5000 = stock nos.
Column b3:b5000 = sizes
Row C1:Z1 = customer
Row C2:Z2 = branch
Now C3 would should display the corresponding total ordered for th
intersecting conditions… as should the other cells
This is the formula I used for C3
SUMPRODUCT(--(Sheet1!B2:B5000=Sheet2!C1),--(Sheet1!C2:C5000=Sheet2!C2),--(Sheet1!E2:E5000=Sheet2!A3),--(Sheet1!F2:F5000=Sheet2!B3),Sheet1!D25000)
It works fine but when you’ve got too many of them excel freezes.
Is there another way around this?
Thanks again