Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Function
I have 3 colums of data with multiple rows. the first two columns contain
"x"'s while the third contains 1 alphabet. I'm trying to set up a formula that says if column 3=N, and there is an "x" in column 1 or 2 count "x" seperatly in each column. (ie. total column would be N, E S,W, then each row would have a total for "x"'s in that particular row. Same thing, if Column 3=N, if Column 3=S, if Column 3=W. I've been trying for days to get this and I'm giving up. Can any of you nice folks help? -- Thank you for you help MO Albany, NY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count function not working, keeps displaying 0 | Excel Worksheet Functions | |||
Function to count unique values? | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
Count If Function | Excel Worksheet Functions | |||
count if function with if statements | Excel Worksheet Functions |