Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Multiple "IF's" or maybe "COUNTIF's"???
I have a worksheet that has various cells of data...some cells contain
numbers. Those numbers span negative (0.5) through (30.0) including half numbers (21.5). Two cells over from those cells with these numbers is either a YES or a NO. I want to count how many YES's and NO's there are for a particular number. In other words a formula will be entered in a random cell asking for the doc to be searched for all (19.5), when found, each case will be analyzed by the second cell over for a YES or NO. The quantity of YES's will be shown as a total in one cell and the quantity of NO's will be shown in a cell below. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple "source" workbooks linked to single "destination" workboo | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) |