Excel formula

Occasional Visitor

I am having trouble writing a formula in Excel.


Cells A3 to F3 row 3 has a number value between 1 and 9. Cells AF2 to AF10 are service numbers, cells AH2 to AH10 are the dollar values for these services. Cells AJ3 is the total dollar amount of cells A3 to F10.


Is there a formula that will recognize the numerical value of cells AF2 to AF10 when entered in cells A3 to F10 to recognize the dollar value listed in AH3 to AH10 to sum in cell AJ3?

1 Reply
As a tip, also post this in the excel forum! :)