C
Craig
Hi,
Following a post I did yesterday 'Count Text to get a Percentage'....my next
post is that I need to count text entries in differing cells to get a result
- Probably Sumproduct is the probably the answer but despite reading up can't
get it.
In Cell A1 (Title Merged across): Have you Carried out a H&S Check?
In Cell A2: Select Job Title
In Cell A3: Is the list (Validation List), Plasterer, Chippy, Brickie
In Cell B3: Answer = Yes or No (Validation)
Q: If I get: Chippy (A3) and Yes (B3)......how can I sum this to get a
figure? to the effect that every Chippy that answers Yes = (a Number) based
on the two answers.......and every Chippy that answers No = (a Number) based
on the two answers?
Q: I will need to get a percentage from this eventually i.e. the total
number of Chippy's that answer Yes = (A Number), Total number of Chippy's
that answer No = (A Number) against the total number of Chippy's...which is I
believe will be:
Total Chippy who answered Yes(divided by)Total Chippy = Answer
Also is it possible to sum more than two Text Answers....having looked at
this discussion group...there only ever seems to be two parts to a
'Sumproduct'...I assume(wrong to assume I know..but) there must be more that
two?
Sorry if my post is too lengthy...got deadline...haven't we all !!!!
Thanks in anticipation
Craig
Following a post I did yesterday 'Count Text to get a Percentage'....my next
post is that I need to count text entries in differing cells to get a result
- Probably Sumproduct is the probably the answer but despite reading up can't
get it.
In Cell A1 (Title Merged across): Have you Carried out a H&S Check?
In Cell A2: Select Job Title
In Cell A3: Is the list (Validation List), Plasterer, Chippy, Brickie
In Cell B3: Answer = Yes or No (Validation)
Q: If I get: Chippy (A3) and Yes (B3)......how can I sum this to get a
figure? to the effect that every Chippy that answers Yes = (a Number) based
on the two answers.......and every Chippy that answers No = (a Number) based
on the two answers?
Q: I will need to get a percentage from this eventually i.e. the total
number of Chippy's that answer Yes = (A Number), Total number of Chippy's
that answer No = (A Number) against the total number of Chippy's...which is I
believe will be:
Total Chippy who answered Yes(divided by)Total Chippy = Answer
Also is it possible to sum more than two Text Answers....having looked at
this discussion group...there only ever seems to be two parts to a
'Sumproduct'...I assume(wrong to assume I know..but) there must be more that
two?
Sorry if my post is too lengthy...got deadline...haven't we all !!!!
Thanks in anticipation
Craig