Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF and programming
I have a few thousand rows Of data, each row has 1-7 outputs in the adjacent
columns. There are 27 different types of outputs. Lets just say A- Z, the maximum amount of outputs for any row is 7. Some only have A, some have, A, B and C and so forth. Each output is in its own column. Basically, i need to a count of all this data, but heres the catch. I need to do counts like this, if a row contains A. B, C and X then count. If a row contains A E Y G then count. I have 8 different things that need to be tallied, and they all have specific definitions from the 27 possible outputs that are in the columns. I hope that this makes sense, and thanks in advance for helping me!! -Adam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif programming function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |