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. |
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. |
All times are GMT +1. The time now is 04:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com