Should I use COUNT IF? from one sheet to another
 

I want to count the totals of various text strings together from sheet 2

eg

on sheet 2 , I want to know the total of Jack, John, Mary & Kates scores as
a whole (each appear atleast 10 times in the different rows)

There are hundreds of rows with different names but need the totals of these
particular 4. The names are are in column D and the totals in column H

I need to show the answer in sheet 1

Please can anybody help?

Should I use COUNT IF? from one sheet to another
 

Hi Amanda,

you can use sumproduct to do it,

=sumproduct(--(sheet1!d2:d100="Jack");(h2:h100))+sumproduct(--(sheet1!d2:d100="John");(h2:h100))+sumproduct(--(sheet1!d2:d100="mary");(h2:h100))+sumproduct(--(sheet1!d2:d100="kate");(h2:h100))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Amanda" escreveu:


I want to count the totals of various text strings together from sheet 2

eg

on sheet 2 , I want to know the total of Jack, John, Mary & Kates scores as
a whole (each appear atleast 10 times in the different rows)

There are hundreds of rows with different names but need the totals of these
particular 4. The names are are in column D and the totals in column H

I need to show the answer in sheet 1

Please can anybody help?

Should I use COUNT IF? from one sheet to another
 

Thanks Marcelo

All working perfect!

"Marcelo" wrote:

Hi Amanda,

you can use sumproduct to do it,

=sumproduct(--(sheet1!d2:d100="Jack");(h2:h100))+sumproduct(--(sheet1!d2:d100="John");(h2:h100))+sumproduct(--(sheet1!d2:d100="mary");(h2:h100))+sumproduct(--(sheet1!d2:d100="kate");(h2:h100))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Amanda" escreveu:


I want to count the totals of various text strings together from sheet 2

eg

on sheet 2 , I want to know the total of Jack, John, Mary & Kates scores as
a whole (each appear atleast 10 times in the different rows)

There are hundreds of rows with different names but need the totals of these
particular 4. The names are are in column D and the totals in column H

I need to show the answer in sheet 1

Please can anybody help?