# two formulas in one cell

October 6, 2010 at 11:37:16
Specs: Windows XP
 I am trying to figrue out how to count all the words "hired" in say I6:I57 using =Countif(I6:I57, "hired) then I want to say if E6:E57 is blank don't count even if I6:I57 has hired. Help.maybe it would be =countif(E6:E57,"*" then something countif(I6:I57,"hired"???

See More: two formulas in one cell

#1
October 6, 2010 at 12:55:29
 This should work.=SUMPRODUCT((E6:A57<>"")*(L6:L57="hired"))The original poster should always write the last response !!!Let us know, if the problem is solved !!!

Report •

#2
October 6, 2010 at 13:49:44
 re: The original poster should always write the last response !!!Let us know, if the problem is solved !!!Unless of course, the person who solved the problem says "You're Welcome" to the OP that said "Thanks for solving my problem!";-)

Report •

#3
October 6, 2010 at 15:49:48
 DerbyDad03Yep, I wrote that, because my list of outstanding issues grows and grows and I'd like to know, if something is solved and can be removed from my list.The original poster should always write the last response !!!Let us know, if the problem is solved !!!

Report •

Related Solutions

#4
October 7, 2010 at 12:01:27
 Thanks a million. It worked!

Report •

#5
October 7, 2010 at 12:29:57
 You are welcome .-)The original poster should always write the last response !!!Let us know, if the problem is solved !!!

Report •

#6
October 7, 2010 at 12:35:46
 paulsep:I understand why you wrote it, and I agree with you for the most part.My only point (and I was trying to be both slightly comical yet serious at the same time) was that the last post might come from the person who solved the problem, even after the OP acknowledged the help.If I solve your problem and you post a Thank You to let me know that the problem was solved, by your rule I'm not allowed to say "You're Welcome. Glad I could help."That would make my response the last response which would mean that your "OP should post last" rule was not followed, even though the OP did in fact that us know that the problem was solved.

Report •