| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
count based on two fields- need as quick as possible
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. |
|
#2
|
|||
|
|||
|
Hi
see your other post P.S.: please don't multipost -- Regards Frank Kabel Frankfurt, Germany Johnny O wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
| formula based on format | Excel Discussion (Misc queries) | |||
| How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
| count based on two fields - need quickly | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Hybrid Mode
