Problem Formula.

[Earlchico]

Hi, Would I be able to email a file to someone to write my formula?

Thanks.

 

[Michael M]

Is this what your after.....

=IF(A3="","",SUMPRODUCT(1*MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1)))

=IF(B3="","",SUMPRODUCT(1*MID(B3,ROW(INDIRECT("1:"&LEN(B3))),1)))

=IF(C3="","",SUMPRODUCT(1*MID(C3,ROW(INDIRECT("1:"&LEN(C3))),1)))

Drag down as required

 

[Earlchico]

Is this what your after.....

=IF(A3="","",SUMPRODUCT(1*MID(A3,ROW(INDIRECT("1:"&LEN(A3))),1)))

=IF(B3="","",SUMPRODUCT(1*MID(B3,ROW(INDIRECT("1:"&LEN(B3))),1)))

=IF(C3="","",SUMPRODUCT(1*MID(C3,ROW(INDIRECT("1:"&LEN(C3))),1)))

This is it Michael this sums all the quantity per Bin..........Now I would like to add
all the totals of these Boxes, E2...... Skids F2.... Filing Cabinets EG ...this is a pretty simple formula for you to write?

This way I can see how many I have of each per Bin, and the total of each for all sites.

Thanks again, much appreciated.

 

[Michael M]

Go to the last row plus 1 in each column and then click on
Editing>> Autosum>>Enter

 

[Earlchico]

Go to the last row plus 1 in each column and then click on
Editing>> Autosum>>Enter

Yeah I done that right away....made mistake sending reply.

Thanks.

 

[Michael M]

Soo...all sorted now ???

 

[Elaszat]

Hi Earlchico,

in columns A to C, does each digit stand for an indivual skid, box or filing cabinet? In other words, do these columns hold other values than reapeated 1? If not, why not use:

=LEN(A3)

as it would provide your desired result with the data you gave us.

Regards,
Elaszat

Edit: Somehow my browser didn't display the posts after post #10. Apologies for redundancy.