cageorge95
New Member
 Joined
 May 20, 2022
 Messages
 2
 Office Version

 365
 Platform

 Windows
To set the scene, I have an order report that has every order placed on the ordering system for every project ever. I want to add up the sum of the 'quantity ordered' and the 'price per unit' for a specific item and a specific site. Therefore, I need to only add the sum of 'quantity ordered' and 'price per unit' for the a specific site and item.
The equation I came up with is:
=SUMPRODUCT(('Orders (general)'!$F:$F="SCN1060")*((ISNUMBER(FIND($A27,'Orders (general)'!$G:$G))))*('Orders (general)'!$J:$J)*('Orders (general)'!$M:$M))
'Orders (general)' is the order sheet that is separate from the sheet I am doing this calculation on.
('Orders (general)'!$F:$F="SCN1060") is the the term to search the item code column for item SCN1060.
((ISNUMBER(FIND($A27,'Orders (general)'!$G:$G)))) is the term to wildcard search the 'project title' column for the project number (the report generates project titles in the format "[Project number]  [Project location]").
('Orders (general)'!$J:$J) is the quantity ordered column.
('Orders (general)'!$M:$M)) is the price per unit column.
My equation results in '#VALUE!'.
Can anyone tell me where I'm going wrong?
The equation I came up with is:
=SUMPRODUCT(('Orders (general)'!$F:$F="SCN1060")*((ISNUMBER(FIND($A27,'Orders (general)'!$G:$G))))*('Orders (general)'!$J:$J)*('Orders (general)'!$M:$M))
'Orders (general)' is the order sheet that is separate from the sheet I am doing this calculation on.
('Orders (general)'!$F:$F="SCN1060") is the the term to search the item code column for item SCN1060.
((ISNUMBER(FIND($A27,'Orders (general)'!$G:$G)))) is the term to wildcard search the 'project title' column for the project number (the report generates project titles in the format "[Project number]  [Project location]").
('Orders (general)'!$J:$J) is the quantity ordered column.
('Orders (general)'!$M:$M)) is the price per unit column.
My equation results in '#VALUE!'.
Can anyone tell me where I'm going wrong?