Sum if functions not copying text
 

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?

Sum if functions not copying text
 

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

Pete

On Jul 3, 12:17*pm, John wrote:
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?

Sum if functions not copying text
 

Yep, it's:

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

A3 being the text I want copied

"Pete_UK" wrote:

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

Pete

On Jul 3, 12:17 pm, John wrote:
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?

Sum if functions not copying text
 

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 #, "")

--
HTH,
Barb Reinhardt



"John" wrote:

Yep, it's:

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

A3 being the text I want copied

"Pete_UK" wrote:

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

Pete

On Jul 3, 12:17 pm, John wrote:
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?

Sum if functions not copying text
 

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!
================================================== ===


"John" wrote in message
...
Yep, it's:

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

A3 being the text I want copied

"Pete_UK" wrote:

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

Pete

On Jul 3, 12:17 pm, John wrote:
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?