Please Help - Sumproduct function

[Sebski]

Hi Guys!

I am a beginner in Excel undertaking a course - so far so good, wouldn't have imagined I enjoy it this much! I have completed my required exercies, though have been assigned an additional 'tricky' question in regards to Excel's sumproduct function - though I suspect it may be a breeze for the advanced users here! I have searched for quite some time for instructions that may be able to help, but have been unable to find anything. Was hoping someone may be able to help - they have even provided a helpful hint!

My exercise, in regards to the attached spreadsheet, is as follows:

Question: In "Sheet4B" write a SUMPRODUCT function to populate Quantity on Hand for each Site from "Sheet4A" where Inv Age > 100.

Hint: syntax sample =SUMPRODUCT(--(Logical Expression 1),--(Logical Expression 2),Array)

We are allowed to use other excel functions to assisst if requried. I would greatly appreciate any assisstance in regards to this, as my brain is about to melt having tried dozens of combinations, and I would love to learn this area of Excel!

Cheers,
Sebski

[zbor]

Yes, hint is OK.

[Fotis1991]

Hi

You can use

=SUMPRODUCT((Sheet4A!$K$2:$K$13036>100)*(Sheet4A!$D$2:$D$13036=Sheet4B!A2)*(Sheet4A!$E$2:$E$13036))

Copy down.