# How to do sumif with more than 3 criteria

1. ## How to do sumif with more than 3 criteria

Dear Friends,

PFA the working file for your reference.

For sumif, my criteria would be combination of I3, I4, col. J.
Is there any formula which are derive the results mentioned in final output sheets ?

3. ## Re: How to do sumif with more than 3 criteria

I Tried SUMIFS but my logic of SUMIFS is not giving me proper results.

4. ## Re: How to do sumif with more than 3 criteria

Dear Friends,
Any luck ?

5. ## Re: How to do sumif with more than 3 criteria

The syntax for SUMIFS is slightly different than for SUMIF. Basically, the range_to_sum comes first after the open bracket (for SUMIF it comes last), and then it is followed by pairs of terms which define the criteria_range and then the criteria, like this:

=SUMIFS(range_to_sum, criteria1_range, criteria1, criteria2_range, criteria2, … and so on …)

The ranges must all be the same size.

Hope this helps.

Pete

There are currently 2 users browsing this thread. (0 members and 2 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