My question; if yes "Y" then add D8 to worksheet tab "summary" how do you do thi

[Treeboy]

My question; if yes "Y" then add D8 to worksheet tab "summary" how do you do this

 

[Joe4]

Your question is a bit vague, and I think needs a bit of clarification.

Where exactly is this "Y" you are looking for (on what sheet and in what cell)?
What sheet is this D8 cell reference referring to?
How many sheets are in your workbook?

Perhaps it would be best to show us an example of your data and expected output.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Treeboy]

Your question is a bit vague, and I think needs a bit of clarification.

Where exactly is this "Y" you are looking for (on what sheet and in what cell)?
What sheet is this D8 cell reference referring to?
How many sheets are in your workbook?

Perhaps it would be best to show us an example of your data and expected output.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

Ok, here are the specifics: Sheet "Jan 2024" if F8 = Y then I8 =- D8-E8, if F8 = N the I8 = 0

 

[Joe4]

You would just have a formula something like this in cell I8:

=IF(F8="N",0,-D8-E8)

Note that if this cell I8 that you are trying to update is on a different sheet than your D8, E8, and F8 references, then you would just need to add your sheet name reference in front of the range references, i.e.

=IF('Jan 2024'!F8="N",0,-'Jan 2024'!D8-'Jan 2024'!E8)

 

[Treeboy]

You would just have a formula something like this in cell I8:

=IF(F8="N",0,-D8-E8)

Note that if this cell I8 that you are trying to update is on a different sheet than your D8, E8, and F8 references, then you would just need to add your sheet name reference in front of the range references, i.e.

=IF('Jan 2024'!F8="N",0,-'Jan 2024'!D8-'Jan 2024'!E8)

Perhaps my description was so good. All on the same worksheet, I do not think that the worksheet name is needed.
IF F8 = NO THEN I8 = ZERO - IF F8 = YES THEN I8 = D8-E8

 

[Joe4]

Yeah, you seem to keep changing the question slightly!
Is it "Y" and "N", or "Yes" and "No"?

And initially you had:

=- D8-E8

and now it is:

=D8-E8

So I am guessing now you need either:

=IF(F8="N",0,D8-E8)

or

=IF(F8="No",0,D8-E8)

depending on whether or not your values are really "N" or "No".

 

[Treeboy]

Yeah, you seem to keep changing the question slightly!
Is it "Y" and "N", or "Yes" and "No"?

And initially you had:

=- D8-E8

and now it is:

=D8-E8

So I am guessing now you need either:

=IF(F8="N",0,D8-E8)

or

=IF(F8="No",0,D8-E8)

depending on whether or not your values are really "N" or "No".

I know, sorry. Let's us Y and N

 

[Joe4]

So, did you try the formula I gave you in the last post?
If "Y" and "N" are the only two options for F8, the formula I have you should work!

=IF(F8="N",0,D8-E8)