Forum Discussion
mplanner
Nov 02, 2021Copper Contributor
summing text converted to numbers
Hello, I am in the process of setting up an attendance "tracker" and need some direction with a formula. I need to convert text codes into numerical values and then sum them together. Th...
OliverScheurich
Nov 02, 2021Gold Contributor
=COUNTIF(C4:AG26,A36)*E36+COUNTIF(C4:AG26,A35)*E35+COUNTIF(C4:AG26,A34)*E34+COUNTIF(C4:AG26,A33)*E33
=SUM(COUNTIF(C4:AG26,A36)*E36,COUNTIF(C4:AG26,A35)*E35,COUNTIF(C4:AG26,A34)*E34,COUNTIF(C4:AG26,A33)*E33)
Is this the formula you are looking for?