I have a spreadsheet with price per foot of 13 different colors of yarn (C4:04)
Below that, I have an inventory of items where I want to plug in the number of feet of each color of yarn used and have it add up the cost in column Q
What has me stumped is that I need to also add the cost of 25 feet of the cell in that row that is highlighted yellow. So if I have cell F5 highlighted, I need the formula to add (F5*F4) to the total sum.
So, I have this, but need to add the extra 25 feet based on whichever cell is yellow:
=SUMPRODUCT(C5:O5*$C$4:$O$4)
I found something in google referencing a colormatch function but I can't get that to work.
Below that, I have an inventory of items where I want to plug in the number of feet of each color of yarn used and have it add up the cost in column Q
What has me stumped is that I need to also add the cost of 25 feet of the cell in that row that is highlighted yellow. So if I have cell F5 highlighted, I need the formula to add (F5*F4) to the total sum.
So, I have this, but need to add the extra 25 feet based on whichever cell is yellow:
=SUMPRODUCT(C5:O5*$C$4:$O$4)
I found something in google referencing a colormatch function but I can't get that to work.
