I'm trying to find a code that I can write for Excel. My goal was to add up all the "X"s in a column and then multiply that total by $25.
Example: If you completed a task, mark "X" in cell B3, and if you completed it again, mark "X" in cell B4. I need another cell to multiply by $25 and add up every "X" in the column. Therefore, this specific cell would equal $100 if 4 of the cells in column B contained a "X".