Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counting more than one criteria in one cell
In a worksheet I have two columns one has a type and the second has a number.
ex. RES(residential), COM(commercial) in column one and the corresponding numbers 001,002 are both RES numerical types. I want to be able to count them individually by the type they fall into. ex. RES has 1200 (type 001) and RES also has 1000 (type 002). The result desired would be RES..... 001.....1200 and next serch in the next cell be RES.....002.......1000. I was trying to use a countif(and statement and it would bring back to few arguments. Can you help. -- Maggie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Counting Values that meet another cells criteria | Excel Worksheet Functions | |||
Counting specific text in a cell | Excel Worksheet Functions | |||
counting instances of words in a worksheet cell | Excel Discussion (Misc queries) | |||
Counting instances in a cell | Excel Discussion (Misc queries) |