I've been using countif statements to total a single column but now
I'm trying to use the countif statement to give me totals based on 2
criteria being met.
For example:
Objective: Report on all "Profile" that are associated with
"Resource".
Formula will search for any cell in column A that says "Profile" AND
any cell in column B that says "Resource". Both criteria must be
within the same row in order to get the desired result.
note: il ne faut pas utiliser une colonne entière dans cette formulle. Note: you should not use a whole column in this formulle.
isabelle
I've been using countif statements to total a single column but now I'm trying to use the countif statement to give me totals based on 2 criteria being met.
For example: Objective: Report on all "Profile" that are associated with "Resource".
Formula will search for any cell in column A that says "Profile" AND any cell in column B that says "Resource". Both criteria must be within the same row in order to get the desired result.
note: il ne faut pas utiliser une colonne entière dans cette formulle.
Note: you should not use a whole column in this formulle.
isabelle
I've been using countif statements to total a single column but now
I'm trying to use the countif statement to give me totals based on 2
criteria being met.
For example:
Objective: Report on all "Profile" that are associated with
"Resource".
Formula will search for any cell in column A that says "Profile" AND
any cell in column B that says "Resource". Both criteria must be
within the same row in order to get the desired result.
note: il ne faut pas utiliser une colonne entière dans cette formulle. Note: you should not use a whole column in this formulle.
isabelle
I've been using countif statements to total a single column but now I'm trying to use the countif statement to give me totals based on 2 criteria being met.
For example: Objective: Report on all "Profile" that are associated with "Resource".
Formula will search for any cell in column A that says "Profile" AND any cell in column B that says "Resource". Both criteria must be within the same row in order to get the desired result.
Any suggestions?
Gaeton Biscardi
Philippe.R
Bonsoir, Un petit coup d'oeil du côté de SOMMEPROD(), si j'ai compris. -- Amicales Salutations XL 97 / 2000 / 2002 Retirer A_S_ pour répondre en privé. Préférez suivre facilement sur le forum : news://msnews.microsoft.com/microsoft.public.fr.excel (Voulez-vous vous abonner ? -> Oui)
"Gaeton Biscardi" a écrit dans le message de news:
I've been using countif statements to total a single column but now I'm trying to use the countif statement to give me totals based on 2 criteria being met.
For example: Objective: Report on all "Profile" that are associated with "Resource".
Formula will search for any cell in column A that says "Profile" AND any cell in column B that says "Resource". Both criteria must be within the same row in order to get the desired result.
Any suggestions?
Gaeton Biscardi
Bonsoir,
Un petit coup d'oeil du côté de SOMMEPROD(), si j'ai compris.
--
Amicales Salutations
XL 97 / 2000 / 2002
Retirer A_S_ pour répondre en privé.
Préférez suivre facilement sur le forum :
news://msnews.microsoft.com/microsoft.public.fr.excel
(Voulez-vous vous abonner ? -> Oui)
"Gaeton Biscardi" <gbiscardi@circadiant.com> a écrit dans le message de
news:3ab68877.0409151202.6f9081b0@posting.google.com...
I've been using countif statements to total a single column but now
I'm trying to use the countif statement to give me totals based on 2
criteria being met.
For example:
Objective: Report on all "Profile" that are associated with
"Resource".
Formula will search for any cell in column A that says "Profile" AND
any cell in column B that says "Resource". Both criteria must be
within the same row in order to get the desired result.
Bonsoir, Un petit coup d'oeil du côté de SOMMEPROD(), si j'ai compris. -- Amicales Salutations XL 97 / 2000 / 2002 Retirer A_S_ pour répondre en privé. Préférez suivre facilement sur le forum : news://msnews.microsoft.com/microsoft.public.fr.excel (Voulez-vous vous abonner ? -> Oui)
"Gaeton Biscardi" a écrit dans le message de news:
I've been using countif statements to total a single column but now I'm trying to use the countif statement to give me totals based on 2 criteria being met.
For example: Objective: Report on all "Profile" that are associated with "Resource".
Formula will search for any cell in column A that says "Profile" AND any cell in column B that says "Resource". Both criteria must be within the same row in order to get the desired result.
