Hello Excel Experts and Awesome People. :-)
I am trying to figure out a formula that automatically adds a dollar amount to a cell if a cell in that row is highlighted (the cell will be highlighted if there is a unique low number in that column). I also need that dollar figure to double, triple, etc if there is more than one highlighted cell in that row. I have attached a spreadsheet that shows what I am looking for. Column "T" is where the dollar figure needs to populate.
Here is the formula I have for another spreadsheet that counts just the "2"'s but the one I attached needs to either count the highlighted cells or the cells that include a unique low number in each column.
=COUNTIF(B3:S3,2)*$T$2
You guys are amazing and I can't wait to hear back from you. Thanks in advance. :-)
Moderator's note: I have moved this to the VBA subforum because it requires changing a constant value that is in the cells in column T, which cannot be done with formulas. --6SJ
Bookmarks