Sum if functions not copying text

[John]

I'm setting up a spreadsheet and wish to transfer data from the front page to
another page based on a Y or N desicion halfway across the front page. It's
a register system and all students' names & ID no's go on the front page
along with a list of activities. Each actibity will get a Y or N desicion
made depending on which activity the student did. The other pages behind the
froint page are for each activity.

I want the name to be transferred to the relevant page based on the Y or N
on the front page, however it won't transfer the text only the ID No.

Can anyone help?

 

[Pete_UK]

Can you post the formula(s) you are using at present?

Pete

 

[John]

Yep, it's:

SUMIF(Sheet1!D3,"Y",Sheet1!A3)

A3 being the text I want copied

 

[Barb Reinhardt]

Your formula doesn't make sense to me for what you want to do. You have a
SUMIF statement

=SUMIF(Sheet1!D3,"Y",Sheet1!A3)

It checks to see if Sheet1!D3 is "Y" and if so, it sums Sheet1!A3. I'm
guessing the ID# is in A3.

Maybe something like this would do what you want

=IF(SUMIF(Sheet1!D3,"Y",Sheet1!A3)>0,Reference to ID #, "")

 

[RagDyeR]

Since the Sum() function bypasses text, you can understand why the Sumif()
function might do the same thing.

Use other functions instead, like:

=If(Sheet1!D3="Y",Sheet1!A3,"")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Yep, it's:

SUMIF(Sheet1!D3,"Y",Sheet1!A3)

A3 being the text I want copied