Sumif Help please

Heath Sanders

I want my totaling cell to add quote on the criteria below.

I have a drop down list in column 1 , in that list I have (con/fine, con/course, con/xtra, ash/fine, ash/course, ash/xtra. grind/fine, grind/course, grind/xtra........this continues for another dozen or so products.

I have m2 rate in column 2, so I enter the data required there.

I have product rate in column 3, so the meter rate (m2) x the product rate give us the cost rate in column 4.

I want the formula to calculate the "product rate" column 3 when ever ash/xtra , con/xtra, grind/xtra.........and the dozen other /xtra are choosen.

When /course or /fine are chosen from any of the drop list I want cost rate column 4 calculated.

Because each product is in a row there will be a mixture of /xtra and /fine /course in the quote. So as long as the totaling cell looks at the correct cells to calculate based on the drop down list. Next question how do you put this together as a formula?  

Shaine Greenwood

Hi Heath,

I've replied with a possible solution in the other thread that you started about this. Please review that here: https://community.smartsheet.com/discussion/nested-if-statement-0

Let me know if you run into issues with that solution.