CountIf
 

I'm hoping someone can give me a little guidance.

I a spreadsheet with several columns, 2 of which are of interest (B and E)

I need to count the number of time there are 'B' in column E for which
column B's value = 'Open' and this base on the total number of values in the
table (variable region).

I started using =COUNTIF(Donnees!E2:E90,"B") but can't seem to get it to
work with the double criteria it must = B and the value in column B = "Open"

Thank you

QB

CountIf
 

=sumproduct(--(22:e90="B")*(b2:b90="Open"))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Question Boy" escreveu:

I'm hoping someone can give me a little guidance.

I a spreadsheet with several columns, 2 of which are of interest (B and E)

I need to count the number of time there are 'B' in column E for which
column B's value = 'Open' and this base on the total number of values in the
table (variable region).

I started using =COUNTIF(Donnees!E2:E90,"B") but can't seem to get it to
work with the double criteria it must = B and the value in column B = "Open"

Thank you

QB

CountIf
 

Try this:

=SUMPRODUCT(--(Donnees!B2:B90="open"),--(Donnees!E2:E90="B"))


--
Biff
Microsoft Excel MVP


"Question Boy" wrote in message
...
I'm hoping someone can give me a little guidance.

I a spreadsheet with several columns, 2 of which are of interest (B and E)

I need to count the number of time there are 'B' in column E for which
column B's value = 'Open' and this base on the total number of values in
the
table (variable region).

I started using =COUNTIF(Donnees!E2:E90,"B") but can't seem to get it to
work with the double criteria it must = B and the value in column B =
"Open"

Thank you

QB

CountIf
 

sorry for the typo mistake

sumproduct(--(e22:e90="B")*(b2:b90="Open))


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:

=sumproduct(--(22:e90="B")*(b2:b90="Open"))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Question Boy" escreveu:

I'm hoping someone can give me a little guidance.

I a spreadsheet with several columns, 2 of which are of interest (B and E)

I need to count the number of time there are 'B' in column E for which
column B's value = 'Open' and this base on the total number of values in the
table (variable region).

I started using =COUNTIF(Donnees!E2:E90,"B") but can't seem to get it to
work with the double criteria it must = B and the value in column B = "Open"

Thank you

QB