I am a basic Excel user. I do a monthly rota which has the staff name in one cell and in the following cell it has the hours worked.
Is there a simple way to write an formula so that Excel takes any data from an adjacent cell with a name in and totals it up?
For example:
A1 - Mark B1 - 5
A2 - Jane B2 - 8
C1 - Mark C1 - 5
D1 - Jane D2 - 8
This continues with many more names throughout the month. Currently I am starting a cell with a staff name in and the in the adjacent cell doing =SUM()
and then clicking each cell they work with a plus sign between.
e.g., A35 - Mark B35 - =SUM(b1+c1)
After my last response to another question, I am thinking there must be an easier way as this is very time-consuming and also prone to error.
C1
; you have names inA1
,A2
,C1
, andD1
; and you have numbers inB1
,B2
,C1
, andD2
. Please edit the question and fix that.SUMIF
formula.