I need to make Sum with 3 criterias

[shadysherif]

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

 

[gaz_chops]

Try sumifs

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

 

[shadysherif]

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]

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

 

[jtakw]

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.

Based on your sample.
Don't understand this part:

C14 = 75
C14 = 90

Book1
	A	B	C	D	E	F	G	H	I	J
1				Oct-18	Nov-18	Dec-18	Jan-19	Feb-19	Mar-19	Apr-19
2	Cairo	Project Manager		50	50	50	50	50	50	50
3
4
5
6	Giza	Project Manager		45	45	45	45	45	45	45
7
8
9
10
11		Feb-19
12
13
14	Cairo	Project Manager	150
15	Giza	Project Manager	135
Sheet606

Cell Formulas
Range	Formula
C14	=SUMPRODUCT((A$2:A$8=A14)*(B$2:B$8=B14)*(D$1:J$1>=B$11)*D$2:J$8)