Filtering with SUMIFS

[Hugh O'Brien]

Hi,

Looking for some assistance with a formula;

SUMIFS(I4:I264,P4: P264,"open",M4:M264,"scrap*")

Looking to sum the filtered value of Column I where it's status is per Column P and contains the text in Column M?

Thanks in advance for any assistance!

Regards, Hugh.

 

[Hugh O'Brien]

Forgive the emoji - that should read 'colon' P