D
Debbi
I can not figure out what formula to use.I need to count the number of times
a certain word "Help Desk" comes up in Column G if the vlaue in Column B is
"1". I think I should use the count if statement but it does not seem to
work. Here is the formula I tried:
=COUNTIF('FP Export data'!$G$2:$G$11000,"Help Desk" & 'FP Export
data'!$B$2:$B$11000,"1")
FP Export data shows info as:
A Column B Column G Column
Lee 1 Help Desk
What I am trying to accomplish is search the B and G columns and count all
instances where Column B=1 and Column G=HelpDesk.
What did I do wrong?. I get the error "you entered too many arguments for
this function."
a certain word "Help Desk" comes up in Column G if the vlaue in Column B is
"1". I think I should use the count if statement but it does not seem to
work. Here is the formula I tried:
=COUNTIF('FP Export data'!$G$2:$G$11000,"Help Desk" & 'FP Export
data'!$B$2:$B$11000,"1")
FP Export data shows info as:
A Column B Column G Column
Lee 1 Help Desk
What I am trying to accomplish is search the B and G columns and count all
instances where Column B=1 and Column G=HelpDesk.
What did I do wrong?. I get the error "you entered too many arguments for
this function."