T
Terry Bennett
I'm sure I must be doing something stupid here ...
I have a very simple database amongst which are 4 columns:
- D: the names of training courses to be held
- G: the dates being held
- H: the course venues
- J: whether the delegate has accepted the invitation to attend ("Y" or "N")
I have named each of these ranges using rows 2 - 200 in each case.
I need a summary table showing, for each course, how many have accepted.
My summary table simply has 4 columns:
- Course (A)
- Date (B)
- Venue (C)
- Acceptance (D)
In cell D2 of the summary table I have:
=SUMPRODUCT(--(Course=$A2)*(Date=$B2)*(Venue=$C2)*(Acceptance="Y"))
but this returns the '#N/A' error message. I can't see anything that might
be causing this (ie; mis-spellings, etc) but it seems that adding-in the
Venue parameter causes the problem (ie; it works fine with just the other 3
variables). But, if I just trim the whole function down to
=SUMPRODUCT(--(Venue=$C2))
that returns the correct result!
Any ideas?
Many thanks.
I have a very simple database amongst which are 4 columns:
- D: the names of training courses to be held
- G: the dates being held
- H: the course venues
- J: whether the delegate has accepted the invitation to attend ("Y" or "N")
I have named each of these ranges using rows 2 - 200 in each case.
I need a summary table showing, for each course, how many have accepted.
My summary table simply has 4 columns:
- Course (A)
- Date (B)
- Venue (C)
- Acceptance (D)
In cell D2 of the summary table I have:
=SUMPRODUCT(--(Course=$A2)*(Date=$B2)*(Venue=$C2)*(Acceptance="Y"))
but this returns the '#N/A' error message. I can't see anything that might
be causing this (ie; mis-spellings, etc) but it seems that adding-in the
Venue parameter causes the problem (ie; it works fine with just the other 3
variables). But, if I just trim the whole function down to
=SUMPRODUCT(--(Venue=$C2))
that returns the correct result!
Any ideas?
Many thanks.