Forum Discussion
formula help
i have a big spread sheet that has a index and match formulas in it. it is looking for the date and shift the filling out information. i have all the data go to different areas with their own formal ...
here is the form i am creating. it is on the pass down tab. cell B12-E15, H12-K15, B18-E21, H18-K21, the cells that are of OEE are a different formulas. but I am tryin to have it look for data by date and shift.
k_musgrove I'm not going to update all your formulas but I think what you really want is SUMIFS(). Here is an example for cell B12:
=SUMIFS('Filler- Retort'!X:X,'Filler- Retort'!$A:$A,'Pass Down'!$D$1,'Filler- Retort'!$B:$B,'Pass Down'!$D$2)
and this will still only pull by the date and shift? since there can be 2 shifts in one day? mtarler
k_musgrove Yes. The formula re-written using words:
SUM ('Filler- Retort'!X:X) IF ('Filler- Retort'!$A:$A) EQUALS ('Pass Down'!$D$1) AND ('Filler- Retort'!$B:$B) EQUALS ('Pass Down'!$D$2)
thank you vey much! the words helped understand what was pulling and why. mtarler