Summing a total for expenses of just one individual

In my sample file attached I would like to sum the total count of expenses for Jane only.  What would be the formula?
Sample.xlsx
daisypetals313Asked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
=SUMIF(A2:A6,"Jane",B2:B6)

Kevin
0
 
daisypetals313Author Commented:
Thanks!
0
 
Roy CoxGroup Finance ManagerCommented:
For this sort of situation I would aleways use a PivotTable. There's a couple of examples in your sample file below, I would also suggest converting the source data toan Excel Table
Sample--2-.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.