×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

#### Jobs

 How does SUMPRODUCT() work for Multiple Criteria Aggregations? by SkipVought faq770-1959 Posted: 29 Jan 17 (Edited 30 Jan 17) I most often need to SUM or COUNT rows in a table that meet a set of criteria. The formulae that can be used to accomplish this task include: SUMIFS(), COUNTIFS(), SUMPRODUCT() I like using SUMPRODUCT() because it is more intuitive than the other two. Here's an example of a simple Structured Table:  Table: tSample Date Name Amt 2/1/2017 Al 22 2/13/2017 Al 33 2/25/2017 Al 23 2/5/2017 Bob 32 2/21/2017 Bob 21 3/9/2017 Bob 12 2/6/2017 Fred 42 2/22/2017 Fred 24 3/3/2017 Al 24 3/17/2017 Bob 14  Here's a summary table that uses SUMPRODUCT():  Name 29-Jan 12-Feb 26-Feb 12-Mar 26-Mar Al 22 56 24 0 Bob 32 21 12 14 Fred 42 24 0 0  This is the formula here: =SUMPRODUCT((tSample[Date]>=C$1)*(tSample[Date]=F$1) * (tSample[Date]

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!