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
|