Special Formula

M

Moreaudjd

Hi,

I have a spreadsheet that looks like that:

Components A1 A2 A3 A4 .... A250
Inventory x x x ... x

Product 1 x x ...
Product 2 x x ...
Product 3 x x ...

Basically, Product 1 & 2 could be done because all necessary components are in
stock, but Product 3 could not be delivered because A3 component is missing.

I would like to have a formula that determines automatically if a given product
can be build based on the inventory.
I started with IF statements, but the formula is too long...

Thanks
 
R

Rob van Gelder

The following is an array formula. You must enter it with CTRL+SHIFT+ENTER
C2:IQ2 is your components
C6:IQ6 is product 3

=(SUM(NOT($C$2:$IQ$2="x")*(C6:IQ6="x"))=0)
 
B

Bob Phillips

Not sure what the criteria are, but you could maybe use COUNTA to check it

For instance add a formula at the right of each row

=IF(COUNTA(A1:IP1)=0,"Build","Don't build")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top