Hello all,

I'm having a problem figuring out how to combine TWO functions to work
properly. What I'm trying to do is the following:

My chart looks like the following

B C D F G H J K
L

Date Name Call Sign Fcst Obs Correct? Fcst Obs Correct?

2 JN Tuff n i FALSE n n
TRUE
4 JN Sku i i TRUE i n
FALSE

Ok...the letters are column that the data is located in. The current
function I'm using is:

=IF(ISERROR((COUNTIF(H9:H33,"TRUE"))/((COUNTIF(H9:H33,"TRUE")+(COUNTIF(H9:H33,"FALSE")) ))),"",(COUNTIF(H9:H33,"TRUE"))/((COUNTIF(H9:H33,"TRUE")+(COUNTIF(H9:H33,"FALSE")) )))

What this does is takes all the FALSEs and TRUEs and counts them all up
and then divides them to give a decimal value at the bottom where this
function is located. What I need help on is adding another function to
this to count ONLY the values (FALSE and TRUE) that is specified by the
NAME.

So, what I'm asking is to have all JNs answers in the Correct? line
added up not all of the results from the top to the bottom. I need to
system to only count up the results of the specified name.

Can anyone help me out on this??? If you need more info, please let me
know. I can email you the file so you can take a look at it. This is
important! Thanks in advance.

Jason


--
drvortex
------------------------------------------------------------------------
drvortex's Profile: http://www.excelforum.com/member.php...o&userid=15896
View this thread: http://www.excelforum.com/showthread...hreadid=487679