Should I use COUNT IF? from one sheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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:
 
Thanks Marcelo

All working perfect!

Marcelo said:
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:
Click to expand...
 
Back
Top