View Single Post
  #1   Report Post  
JO
 
Posts: n/a
Default count based on two fields - need quickly

HELLO,
I am trying to get a count based on two fields.
I want to return the count based on if cells in col B = X and cells in col
A = Y
I have tried "=COUNTIF(H23:H999,A1) + COUNTIF
(B23:B999,A8)" but it is giving me the count of the result plus the count
of the second result.
Can anyone help.