Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
I have a simple spread sheet with several different column headings. A1 thru
A7 contain different headings requiring different data for each row. A3 is a heading which requires an 11 digit numeric code (never the same number). A7 requires either a "Positive" or "Negative" finding. I need to find out what my effiency rate is based on the number of the 11 digit numeric codes versus the "Positive" findings only. Help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Question
SkyDiver,
=COUNTIF(B7:IV7,"Positive")/COUNTIF(B3:IV3,"<") gives the fraction of entries (filled in values on row 3) that have "Positive" in row 7. Note that this doesn't check that all values are filled in, paired properly, etc. That would require a different approach: =SUMPRODUCT((B3:IV3<"")*(B7:IV7="Positive"))/SUMPRODUCT((B3:IV3<"")*(B7:IV7<"")) HTH, Bernie MS Excel MVP "Skydiver" wrote in message ... I have a simple spread sheet with several different column headings. A1 thru A7 contain different headings requiring different data for each row. A3 is a heading which requires an 11 digit numeric code (never the same number). A7 requires either a "Positive" or "Negative" finding. I need to find out what my effiency rate is based on the number of the 11 digit numeric codes versus the "Positive" findings only. Help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question | Excel Worksheet Functions | |||
Repeating Formula Question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
I have a question regarding countif formula. | Excel Worksheet Functions |