# Sumifs and countifs

1. ## Sumifs and countifs

Can you use a cell reference with the SUMIFS and COUNTIFS formulas and Defined Names?

To clarify, I'm wondering if you can do this the following.

Create a Defined Name of SalesRegion (Northeast, Southeast...etc.) & Sales (SalesNumber1....SalesNumbern).

I know you can =SUMIFS(Sales, SalesRegion, "="&"Southeast")

If you had the words "SalesRegion", "Sales" in cells A1 and A2, respectively, could I do this? (I know you can put "Southeast" in a cell A3 and it works.)

=SUMIFS(A2,A1,"="&A3)

If I can do this, what am I doing wrong to not achieve the correct result?

2. ## Re: Sumifs and countifs

Perhaps something like this...(untested):
``Please Login or Register  to view this content.``
Does that work?

3. ## Re: Sumifs and countifs

You need to include the INDIRECT function then...

=SUMIFS(INDIRECT(A2),INDIRECT(A1),A3)

4. ## Re: Sumifs and countifs

You guys just saved me a ton of time!!! Thank you!!! It worked like a charm!!

There are currently 1 users browsing this thread. (0 members and 1 guests)