Nested SumIF Formula

[lee ward]

Hi all, this one is really battering my brain & I am in need of desperate help to solve this, Basic written description of what i am trying to achieve below

i wish to search for a certain product code in column F:F & return a quantity value from column D:D but only if column C:C shows the letter "O" (outstanding)

I already have a formula that searches the product code in F:F & returns the quantity value from D:D however to get this to only show the quantity from D:D if C:C shows the letter "O" I am completely lost, example of the formula I am currently using below

=SUMIF(F9:F100000,"*032.46.848*",D9:D100000)

any help would be much appreciated,
Regards
Lee

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUMIFS(D9:D100000,F9:F100000,"*032.46.848*",C9:C100000,"O")

 

[lee ward]

Hi thanks for the reply, this was the first formula i tried but excel states "too many arguments" for this formula

 

[Fluff]

Oops, forgot to add the S. It should be SUMIFS
I've updated the original formula

 

[lee ward]

Thank you very much this will help me out no end, really appreciated

 

[Fluff]

You're welcome & thanks for the feedback.