Thread: Using countif based on values of cells in other columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pimamedic Pimamedic is offline
external usenet poster
  
Posts: 64
Default Using countif based on values of cells in other columns
=COUNT(if A1:A6=f,4,0)

Change the range as needed

"bmac" wrote:

Hello, I would like the count the number of times the number "4" appears in
column D only when the value "F" appears in the same row in column B. I don't
want to sum the 4 values, I just want to count them.

Any help appreciated,

BMAC
Reply With QuoteReply With Quote