# I need to make Sum with 3 criterias

##### New Member

in C14: I need it to calculate the sum of the remaining months starting this month, also when the location and function match
so that

C14 = 75
C14 = 90

### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### gaz_chops

##### Well-known Member
Try sumifs

=sumifs(sum range, criteria range, criteria, criteria range, criteria)

##### New Member
I tried Sumifs but couldn't because it will contain also index,match function and I don't how exactly it's done
if you can help me with the exact function i'd really appreciate it

#### gaz_chops

##### Well-known Member
With the information you have provided, it's not possible. Give more details of the data/structure etc.

#### jtakw

##### Well-known Member
Hi,

Please post data in a Table format that your Helpers can copy and paste into Excel for testing, rather than a picture, which can not be copied.

Don't understand this part:
C14 = 75
C14 = 90

Book1
ABCDEFGHIJ
1Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19
2CairoProject Manager50505050505050
3
4
5
6GizaProject Manager45454545454545
7
8
9
10
11Feb-19
12
13
14CairoProject Manager150
15GizaProject Manager135
Sheet606
Cell Formulas
RangeFormula
C14=SUMPRODUCT((A\$2:A\$8=A14)*(B\$2:B\$8=B14)*(D\$1:J\$1>=B\$11)*D\$2:J\$8)

Replies
6
Views
251
Replies
2
Views
145
Replies
3
Views
595
Replies
3
Views
452
Replies
0
Views
550

1,190,783
Messages
5,982,894
Members
439,804
Latest member
melD94

### 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.

### Which adblocker are you using?

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

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