Filtering with SUMIFS

H

Hugh O'Brien

Joined
Mar 12, 2015
Messages
2
Reaction score
0
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.
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumifs problem 1
SUMIFS function help 6
using sumifs with multiple criteria? 3
Excel 2007 has a formula "sumifs" - what do I use in Excel 2003 2
Using Sumifs combined with an "Or" 4
SumIFS Cell 1
sumifs formula in excel 2007 5
sumifs/sumproduct 8

Top