What am I missing in my formula?

[birdherder27]

I'm missing something in my =countifs and =sumifs...I've gone in circles to the point where I'm going crosseyed.

Basically...

If Zak Astorg on Sheet 1 has 3+2+7 points, then Zak Astorg on Sheet 2 has 12 total points.

What formula would you use to tabulate total points for each person across worksheets?

TYIA!!!

 

[Eric W]

Welcome to the MrExcel Forum!

Try:

Book2
	A	B	C
1	Last	First	Points
2	Astorg	Zak	3
3	Astorg	Zak	2
4	Astorg	Zak	7
5	Barley	Dale	6
6	Barley	Dale	3
7	Cannel	Mary	8
8	Dillon	Terry	5
Sheet1

Book2
	A	B	C
1	Last	First	Points
2	Astorg	Zak	12
3	Barley	Dale	9
4	Cannel	Mary	8
5	Dillon	Terry	5
Sheet2

Cell Formulas
Range	Formula
C2:C5	C2	=SUMIFS(Sheet1!$C$2:$C$8,Sheet1!$A$2:$A$8,A2,Sheet1!$B$2:$B$8,B2)

Note that SUMIFS was not available in Excel 2007, but there are options if you need it in that version.

 

[birdherder27]

YESSSSSSSSSSSSSSSSSSSS! THANK YOU!!!!