| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
record count using two different cells
Hello,
I am trying to get a record count based on two fields say col A = X and col B=Y then count the record. I have used =COUNTIF(H23:H999,A1) + COUNTIF(B23:B999,A8), but it looks to be giving me the result of the first plus the result of the second. Can anyone help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Count non-colored cells | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| Count cells with data | New Users to Excel | |||
Threaded Mode
