Formula to get the number of times a company name appears in a month and year

[MariahCab]

In the Referrals & Admissions Analysis sheet I am needing to calculate how many times a Referral Source appears in the Referrals & Admissions sheet as well as how many of them were actually admitted to our services.

Prior to this I had just been tracking overall so I only needed the =COUNTIF(Referrals & Admissions!A:A, "Referral Source") formula but am unsure of how to get more specific than this.

thank you for any help!

 

[MountainFog]

Untested, but something like this:

=COUNTIFS(Referals & Admissions!A:A,"Referral Source",Referals & Admissions!B:B, ">=" & EOMONTH(B1,-1)+1, Referals & Admissions!B:B, "<=" & EOMONTH(B1,0))

=COUNTIFS(Referals & Admissions!A:A,"Referral Source",Referals & Admissions!B:B, ">=" & EOMONTH(B1,-1)+1, Referals & Admissions!B:B, "<=" & EOMONTH(B1,0),Referals & Admissions!G:G,"Yes")

 

[MariahCab]

Untested, but something like this:

=COUNTIFS(Referals & Admissions!A:A,"Referral Source",Referals & Admissions!B:B, ">=" & EOMONTH(B1,-1)+1, Referals & Admissions!B:B, "<=" & EOMONTH(B1,0))

=COUNTIFS(Referals & Admissions!A:A,"Referral Source",Referals & Admissions!B:B, ">=" & EOMONTH(B1,-1)+1, Referals & Admissions!B:B, "<=" & EOMONTH(B1,0),Referals & Admissions!G:G,"Yes")

when i entered this it is opening my file explorer to upload something to it.

 

[MountainFog]

Ooops. Referrals is spelled wrong. You can delete the referrals & admissions! and replace it with the actual reference.

 

[MariahCab]

Ooops. Referrals is spelled wrong. You can delete the referrals & admissions! and replace it with the actual reference.

LOL I didn't catch it either! it doesn't count them but thank you for trying!

 

[MountainFog]

can you upload a file via dropbox?

 

[MariahCab]

can you upload a file via dropbox?

Mr Excel Help.xlsx

Shared with Dropbox

www.dropbox.com

Here you go!

 

[MountainFog]

Column B & Dragged Down:

=COUNTIFS('Referrals $ Admissions'!$A:$A,$A3,'Referrals $ Admissions'!$B:$B, ">=" & EOMONTH(B$1,-1)+1,'Referrals $ Admissions'!$B:$B,"<="&EOMONTH(B$1,0))

Column C & Dragged Down:

=COUNTIFS('Referrals $ Admissions'!$A:$A,$A3,'Referrals $ Admissions'!$B:$B, ">=" & EOMONTH(B$1,-1)+1,'Referrals $ Admissions'!$B:$B,"<="&EOMONTH(B$1,0),'Referrals $ Admissions'!$G:$G,"YES")

Copy and paste those columns in F:G and so on

 

[MariahCab]

you are my new

Column B & Dragged Down:

=COUNTIFS('Referrals $ Admissions'!$A:$A,$A3,'Referrals $ Admissions'!$B:$B, ">=" & EOMONTH(B$1,-1)+1,'Referrals $ Admissions'!$B:$B,"<="&EOMONTH(B$1,0))

Column C & Dragged Down:

=COUNTIFS('Referrals $ Admissions'!$A:$A,$A3,'Referrals $ Admissions'!$B:$B, ">=" & EOMONTH(B$1,-1)+1,'Referrals $ Admissions'!$B:$B,"<="&EOMONTH(B$1,0),'Referrals $ Admissions'!$G:$G,"YES")

Copy and paste those columns in F:G and so on

you are literally the best!! thank you!!