PeregrinTook
Board Regular
- Joined
- Feb 9, 2006
- Messages
- 157
Hey all,
Having a mind-blank and can't get this formula to work - hope someone here can help please!
I need to look up a large table and get the sumproduct of (Cartons x KG/Carton) where 'Deleted'=No.
The following worked perfectly before I needed to introduce the conditional check on Deleted status:
=SUMPRODUCT(SupplySummary!$C$4:$C$504,SupplySummary!L$4:L$504)
Where Col C is KG/Carton & Col L is Cartons.
I have tried many combinations of adding in SupplySummary!$AT$4:$AT$504="No" but just can't get it to work.
Can someone please help me with the structure for this scenario?
Many thanks
PT
Having a mind-blank and can't get this formula to work - hope someone here can help please!
I need to look up a large table and get the sumproduct of (Cartons x KG/Carton) where 'Deleted'=No.
The following worked perfectly before I needed to introduce the conditional check on Deleted status:
=SUMPRODUCT(SupplySummary!$C$4:$C$504,SupplySummary!L$4:L$504)
Where Col C is KG/Carton & Col L is Cartons.
I have tried many combinations of adding in SupplySummary!$AT$4:$AT$504="No" but just can't get it to work.
Can someone please help me with the structure for this scenario?
Many thanks
PT