Realising values from more than one cell
magic Our Morris!
done the job great, especially as all the cells WILL start off blank...
thanks Pete
Pete
Pete_UK wrote:
You could try this:
=--ISNUMBER(C3)+ISNUMBER(M7)+ISNUMBER(H13)
Each function returns a 1 if you have any numbers in the appropriate
cell - this assumes that the cells are blank until the points are
entered.
Hope this helps, and that your spreadsheet is cracked !.
Pete
DubboPete wrote:
Hi all,
I want to create a points table, from four groups of four teams.
I am trying to get a value in a cell in my points table to realise if a
team has played one, two or three games.
Cells in question might be C3, M7 and H13, and the team in question is
A1 (Group A, Team 1 - NOT A CELL REFERENCE!). All entries might not
run sequentially.
If a score is entered in any one of the aforementioned cells, I want
the Points table's 'played' cell (T2) to increment from 1 to 3.
So, logically, if the first score is entered in C3, then (T2=1).
Subsequently, when the next score is entered in M7, then (T2=2) and so
on to include H13. There will only be 3 games played per team.
Once someone cracks that formula for me, I think I am a long way to
cracking the rest of the spreadsheet!
Hope I'm on the right Excel list anyway, and thanks in anticipation!
DubboPete
|