# Sumifs with multiple criteria in multiple columns

1. ## Sumifs with multiple criteria in multiple columns

Hi,

I am trying to get sum based on multiple criteria from 3 columns and single criteria from 1 columns.

I have used combination of Sumproduct and sumifs functions, however it is not working.

Please check the attached file for details.

Any help highly appreciated.

2. ## Re: Sumifs with multiple criteria in multiple columns

Try

=SUMPRODUCT((ISNUMBER(MATCH(DATA!\$A\$2:\$A\$110,\$C\$8:\$C\$10,0)))*(ISNUMBER(MATCH(DATA!\$B\$2:\$B\$110,\$D\$8:\$D\$10,0)))*(ISNUMBER(MATCH(DATA!\$C\$2:\$C\$110,\$E\$8:\$E\$10,0)))*(DATA!\$E\$2:\$E\$110=C13)*DATA!\$F\$2:\$F\$110)

Copy down

3. ## Re: Sumifs with multiple criteria in multiple columns

Hi Ace_XL,

Formula is working fine in case of selection of multiple criteria, however it is not working if criteria mentioned as "*" (means for all records in database).

e.g. Earlier in sumifs function i used "*" as criteria for sum of all the records in database, have created dynamic drop-downs for selection of criteria/options for end user to view the summary of data.

Please refer attached file for more details.

4. ## Re: Sumifs with multiple criteria in multiple columns

Is there any alternative instead of using "*" for all the records??

5. ## Re: Sumifs with multiple criteria in multiple columns

Hello Experts,

Can any one help me out for above problem.....

6. ## Re: Sumifs with multiple criteria in multiple columns

Any help on above . . . .

7. ## Re: Sumifs with multiple criteria in multiple columns

Is there any solution for the same ? ? ?

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1