I need help with a formula to calculate the number of clients with a particular status by site. I was trying to use COUNTIFS() function. File attached.
Thanks in Advance for Helping
I need help with a formula to calculate the number of clients with a particular status by site. I was trying to use COUNTIFS() function. File attached.
Thanks in Advance for Helping
Last edited by stubbsj; 10-22-2011 at 11:31 AM.
Would a Pivot Table be an option? Easiest and fastest way in your case
In C11:
=COUNTIFS($J$4:$J$14, $A11, $L$4:$L$14, RIGHT(C$10,1))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
No, need a calculated number. I'm not allowed to use pivot tables
Is this a homework question?I'm not allowed to use pivot tables
Thanks Jerry - That solved the problem!
No, company (I work for HP). They don't want pivot tables on the spreadsheet I'm working on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks