I have two columns with the possible letter entries of "L", "M", and "H"; the numerical values for each will be 1, 3, and 5, respectively. I want to multiply the values in those two columns, with the numerical value displayed in a third column. I have modified the following formula - =SUM(COUNTIF(H4:I4,"L")*1+COUNTIF(H4:I4,"M")*3+COUNTIF(H4:I4,"H")*5) - and replaced SUM with PRODUCT, as well as replacing the "+" with "*", both to no avail. I would appreciate any assistance on this issue. Thank you.
Bookmarks