Hi
looking for some help please, i'm trying to do a sumifs with multiple criteria and a partial text but i seen to be having issues
column A will contain "ABC and DEF" column L is the revenue amount and column F contains text "RNXXXX" (amongst other text) but i only want it to pick up the rev amount that corresponds to "ABC & DEF and "RN"
does that make sense?
column A Column F Column L Result would = 2,500
ABC RNXXX 1,000
DEF RNXXX 1,500
ABC POXXX 2,000
Many thanks with any help you can provide
looking for some help please, i'm trying to do a sumifs with multiple criteria and a partial text but i seen to be having issues
column A will contain "ABC and DEF" column L is the revenue amount and column F contains text "RNXXXX" (amongst other text) but i only want it to pick up the rev amount that corresponds to "ABC & DEF and "RN"
does that make sense?
column A Column F Column L Result would = 2,500
ABC RNXXX 1,000
DEF RNXXX 1,500
ABC POXXX 2,000
Many thanks with any help you can provide