# multiple requirement sum

Status
Not open for further replies.

#### lionstud31

##### Board Regular
I am trying to find a way to get a sum only if it meets more than one requirement. Here's what is is: in column A, I have the employee's names. In column B, I have the date. In column C, I have a dollar amount. What I want to do is get a total for each person's transactions in a certain date range. For example, I want the total John sold in September. Can anyone of you excel Wiz's out there help me?

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### texasalynn

##### Well-known Member
I am trying to find a way to get a sum only if it meets more than one requirement. Here's what is is: in column A, I have the employee's names. In column B, I have the date. In column C, I have a dollar amount. What I want to do is get a total for each person's transactions in a certain date range. For example, I want the total John sold in September. Can anyone of you excel Wiz's out there help me?

try this
Code:
``=sumproduct((A2:a100="John")*(month(b2:b100)=9)*(c2:c100))``
HTH

#### daniels012

##### Well-known Member
Every September or just this years September or last years September?

Michael

Status
Not open for further replies.

Replies
0
Views
157
Replies
3
Views
57
Replies
0
Views
135
Replies
6
Views
49
Replies
1
Views
64

Threads
1,137,366
Messages
5,681,072
Members
419,950
Latest member
BeckiJae

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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