SUMIFS Criteria

[pauleapo]

Hello everyone,

I have the following formula which calculates volumes of materials based on a product, the final part of the formula which needs to equal the word 'timber' also needs to calculate if the value is 'wood'. So it needs to have either 'Timber' OR 'Wood'

=SUMIFS($E$12:$E$404,$B$12:$B$404,$AJ13,$M$12:$M$404,$U$12,$O$12:$O$404,$S$12,$J$12:$J$404,"Timber")

I really hope this makes sense and someone can assist me with this, MrExcel forums have not failed me in the past

Thanks in advance for any replies

Paul

 

[BarryL]

Do you want the sum of timber and wood, or timber or wood? as in can timber and wood be in $J$12:$J$404 at the same time? do you want to differentiate between timber and wood? can you change the "Timber" in the formula to a cell reference so you can change it when needed ?

 

[pauleapo]

Barry,

Thanks for the quick reply, Timber and Wood are to be classed as the same product so the sum would need to add any cell in the range that has either timber OR wood. Yes timber and wood can be in the range $J$12:$J$404

 

[shg]

=SUM(SUMIFS($E$12:$E$404, $B$12:$B$404, $AJ13, $M$12:$M$404, $U$12,$O$12:$O$404, $S$12, $J$12:$J$404, {"Timber","Wood"}))

 

[pauleapo]

SHG,

Thank you, this worked an absolute treat