Drop down in multiple columns. I want to do a sum at the end for each column that has a specific value. S0
SUM OF If C10= "Specific_Value", (C52*D47/36), else 0, PLUS If E50= "Specific_Value", (E52*D47/36) PLUS if G50="Specific_Value" (G52*H47*36), else 0)
Solved by F. Q. in 11 mins