SUMIFS function for 2 criteria two-way table
Solved
tsetsebcn
Posted messages
8
Status
Member
-
Britanian -
Britanian -
Hello,
I am desperately looking for a formula that would allow me to do something like SUMIF but with two criteria on a range (table) with 2 entries. Is this possible?
In my specific case, and see the example in the image, I would like to obtain the seller's target in the yellow cell based on the month and the seller.
Thank you in advance for your help
Sebastien
I am desperately looking for a formula that would allow me to do something like SUMIF but with two criteria on a range (table) with 2 entries. Is this possible?
In my specific case, and see the example in the image, I would like to obtain the seller's target in the yellow cell based on the month and the seller.
Thank you in advance for your help
Sebastien
2 answers
Hello,
Starting from Excel 2007, you can use SUMIFS()
Before that, you can use SUMPRODUCT()
--
Best regards
Patrice
Starting from Excel 2007, you can use SUMIFS()
Before that, you can use SUMPRODUCT()
--
Best regards
Patrice
tsetsebcn
Posted messages
8
Status
Member
1
Thank you Patrice for the response. I will take Via's proposal which is all ready :)
Hello to both of you
In your example, it's not a sum that you apparently want but a value from a matrix based on the abscissa and the ordinate
In this case, you need to use the combination INDEX MATCH
=INDEX(range of objectives; MATCH(salesperson name or cell address with name; vertical range of the 3 salespeople; 0); MATCH(month sought or cell address with month; horizontal range of the 12 months; 0))
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
In your example, it's not a sum that you apparently want but a value from a matrix based on the abscissa and the ordinate
In this case, you need to use the combination INDEX MATCH
=INDEX(range of objectives; MATCH(salesperson name or cell address with name; vertical range of the 3 salespeople; 0); MATCH(month sought or cell address with month; horizontal range of the 12 months; 0))
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein