How do I count to different variables in excel

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

Jon,

Not sure what you mean by 2c(?). Twice the value of column C, or the string "2c" Anyway, one of
these should help:

=SUMPRODUCT((B1:B100=2*C1:C100)*(D1:D100 = "Adventure"))
=SUMPRODUCT((B1:B100="2c")*(D1:D100 = "Adventure"))

HTH,
Bernie
MS Excel MVP


"Jonhart75" <[email protected]> wrote in message
news:[email protected]...
> 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

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

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

Jon,

Not sure what you mean by 2c(?). Twice the value of column C, or the string "2c" Anyway, one of
these should help:

=SUMPRODUCT((B1:B100=2*C1:C100)*(D1:D100 = "Adventure"))
=SUMPRODUCT((B1:B100="2c")*(D1:D100 = "Adventure"))

HTH,
Bernie
MS Excel MVP


"Jonhart75" <[email protected]> wrote in message
news:[email protected]...
> 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