View Single Post
  #2   Report Post  
bpeltzer
 
Posts: n/a
Default

Switch to DCOUNT instead. It's a bit more complex, but also more powerful.
You'll need a set of cells to form the criteria, and you're therefore able to
specify criteria for multiple columns at the same time.

"Jonhart75" wrote:

Hi I am try to use a countif command to display results of 2 diferent
variables
I have two coloums b and d and want to display the results as a count if b =
2c and d = adventure