SUM multiple cells based on multiple cell criteria,not a range

"based on the criteria in other cells of that column"

Example data please.

Is there any logic to your data? We need to see exactly how it's setup to give detailed solutions. For your above scenario, this would work:

IF(OR(B14="MARSIL",B31="MARSIL"),B7+B37,"")

Can you upload a sample workbook instead? You can do this by clicking on Go Advanced below, then Manage Attachments.

You can use something like this in B11 and drag down to B12; you'll most likely need to alter the ranges to match your actual workbook:

=SUM(OFFSET($A$1,MATCH(A11,$B$1:$B$8,0)+2,1))

Originally Posted by georgiepod

Thank you, would that work if I multiple entries meeting the factory critieria, for instance to China Silk's?

This formula will only match the first occurrence. With the addition of a helper column, a relatively simple formula can be created to create your desired result. Otherwise, there's always VBA.

Try in B9:

=SUM(IFERROR((((B1:B5="CHINA SILK")+(B1:B5="MARSIL"))*B4:B8),0))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.