extraction data from excel spreadsheet

Hi and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

Here is a vba solution

Please Login or Register  to view this content.

Do you have the list of part numbers, or does that need to be extracted too?

Also, would it be OK to just list all parts, with their counts and amounts, and either just use that list, or extract from that?

Assuming you have that list of parts, then this will pull out the sum of all orders placed more than 5 times, and that have more than 10 ordered (it differs from your sample total)
=IF(COUNTIFS($C$3:$C$76,B81)>=5,SUMIFS($F$3:$F$76,$C$3:$C$76,B81,$D$3:$D$76,">=10"),"")
and for the count...
=IF(COUNTIFS($C$3:$C$76,B81)>=5,COUNTIFS($C$3:$C$76,B81,$D$3:$D$76,">=10"),"")

@FDibbins
My understanding of what the OP is wanting is if the order count > 5 with order qty > 10 then sum the Total amount ordered. And not just Where the sum of order count > 5 with order qty > 10. Idk I could be wrong.

If possible also if the total order value of the same part numbers could be incorportated into the same formulae that would be great but this is not a priority at this stage.

Please Login or Register  to view this content.

I looked at it that way too, and you could be right. Then the formula becomes...
=IF(COUNTIFS($C$3:$C$76,B81)>=5,SUMIFS($F$3:$F$76,$C$3:$C$76,B81),"")

I know when I wrote my code I came up with the same values your first formulas produced.

If you can use a vba solution then my solution in post 4 doesn't rely on your part numbers at the bottom.

Yes it will do what you want. If it doesn't we can modify the code