Forum Discussion
Excel Formula Help
I at best a novice with Excel so I am reaching out for help. I am trying to calculate hours based of of a letter code for an activity and need the formula to calculate a sum based of of the letter in...
The Matt Mickle's formula must be entered in individual cells (AC3, AD3 and AE3) and later drag it down. You can use instead, in AC3:
=COUNTIF($B3:$AA3,LEFT(AC$2))
And later drag it right and down. Blessings!
=COUNTIF($B3:$AA3,LEFT(AC$2))
And later drag it right and down. Blessings!
