I have spreadsheet data similar to below:
Spreadsheet tab name TEAMS
Col A Col B Col C
TOM RED 0
JOE RED 100
BOB WHITE 200
PAT WHITE 300
DAN BLUE 400
KEN BLUE 500
I am hoping for a formula to place in a cell that will be located within another spreadsheet tab in the same file, that will look at Column B above, and where RED or BLUE only (but not WHITE or other), will return the value in Column C. Also, if the value is zero, as in the first row above, I would like it to return a numerical 0, not #N/A if possible.
Any help will be most appreciated.
Thank you,
vantilian
Spreadsheet tab name TEAMS
Col A Col B Col C
TOM RED 0
JOE RED 100
BOB WHITE 200
PAT WHITE 300
DAN BLUE 400
KEN BLUE 500
I am hoping for a formula to place in a cell that will be located within another spreadsheet tab in the same file, that will look at Column B above, and where RED or BLUE only (but not WHITE or other), will return the value in Column C. Also, if the value is zero, as in the first row above, I would like it to return a numerical 0, not #N/A if possible.
Any help will be most appreciated.
Thank you,
vantilian