Trying to figure out a formula that references a text list. If someone chooses one text (Work Hours), I want it to sum, but if they choose another text (Total Hours), I want it to do a calculation. I basically want to combine these two formulas. I was thinking SUMIF(OR, but can't seen to get it right.
SUMIF (this says that) OR SUMIF (that says this)*0.8
Bookmarks