Good Day all,
I have a formula that pulls data when a specific criteria is met,
however i would like to modify the formula to pull data if 2 criteria are met.
here is what i havew now:=IFERROR(1/(1/SUMIFS('MATERIAL DATA'!$K$5:$K$1994,'MATERIAL DATA'!$L$5:$L$1994,BOM!$K5)),"")
so this asks sum sheet called material data k5 to 5 1994 if sheet called material data l5 to I1994 matches sheet called BOM k5
this works perfecty however i would like to add a second match . and i am not sure where i would put it in the formula to have it work.
the added part to the formula is: also search sheet called material data in cells w5:w1994 for "MF"or"CS" if the search matches MF then sum only the ones that match MF if the search matches CS then sum only the ones that match CS.
i hope ive made it clear enough.
if not let me know
thanks for any help
mike rand
Bookmarks