Need formula for counting

**sstravs** · 09-18-2012, 11:49 AM

Hi All,

Need some help. (obviously

)

I have a spreadsheet with a service level column (starting at F13). We are putting a "1" in the service level columns to indicate service level (1, 2 & 2). In column W there is a provider name. At the top of the spreadsheet I would like to count the number of referrals by service level by provider.

Attached is the workbook.

**Fotis1991** · 09-18-2012, 11:51 AM

Hi to you.

First you have to change your title, according to the forum rules.

Then it would be better for all, to upload a small sample workbook.

**sstravs** · 09-18-2012, 05:20 PM

Thanks Fotis! Hopefully the title is better? I also attached the workbook.

**FDibbins** · 09-18-2012, 06:04 PM

try playing around with the countifS() function, and see if that gives you what you need?

**sstravs** · 09-18-2012, 06:45 PM

I did and I couldn't get it to work. I need it to only count those cells with a "1" when the W column lists the correct provider.

**Fotis1991** · 09-19-2012, 01:42 AM

Originally Posted by sstravs

Thanks Fotis! Hopefully the title is better? I also attached the workbook.

Title is better but you need to do this in your first post! So next time you'll know it!

Your sample sheet has no data... So i quess that you need something like this. Try.

=COUNTIFS(F:F,1,W:W,B3)

**sstravs** · 09-25-2012, 11:35 AM

Hi Fotis,

Thank you. I tried your suggestion but received an error message that said "You've entered too many arguments for this function".

**Fotis1991** · 09-25-2012, 11:45 AM

Looks strange to me

Take a look to the example

**sstravs** · 09-25-2012, 11:52 AM

Oh! I was over complicating it. I thought when you put =COUNTIFS(F:F,1,W:W,B3) you were implying I should put the range of F and W to be searched. THANK YOU!