# Multiple IF Statements in COUNTIFS formula referencing different cells (is this even possible?!)

#### stbrooks13

##### New Member
I'm not sure if this is possible, so here goes...

I am creating a scorecard in excel that measures recruiting data points by my firm's region/market/office. I would like to use the same scorecard for all three.

I have the field (W4) to select whether it's a region/market/office, and (W3) to select the actual region/market/office.

Here's an example of one of the formulas I'm toying around with to calculate offers accepted within our fiscal year that we received from an "other" source (by region/market/office):

COUNTIFS(Source,"Other",OfferAccepted,"<42156",OfferAccepted,">41790",IF(W4=Regions,"Region,W3",IF(W4=Markets,"Market,W3","Office,W3")))

I guess I could always do something to the following effect, but even that's resulting in "too few argument" errors.

=IF(W4="Regions",COUNTIFS(Source,"Other",OfferAccepted,"<42156",OfferAccepted,">41790",Region,W3),IF(W4="Markets",COUNTIFS(Source,"Other",OfferAccepted,"<42156",OfferAccepted,">41790",Market,W3),IF(W4="Local",COUNTIFS(Source,"Other",OfferAccepted,"<42156",OfferAccepted,">41790",Office,W3,0)))

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### ukmikeb

##### Well-known Member
Hi

Probably :-

Code:
``COUNTIFS(Source,"Other",OfferAccepted,"<42156",OfferAccepted,">41790",INDEX((Region,Market,Office),,,MATCH(W4,{"Regions","Markets","Local"},0)),W3)``

hth

Replies
27
Views
4K
Replies
4
Views
412
Replies
12
Views
491
Replies
2
Views
842
Replies
2
Views
646

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,982
Messages
5,834,682
Members
430,309
Latest member
Deepjuillet

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back