Sumifs horizontal vertical

Hi,

Could anybody help me with creating a formula, i'm really stuck. Your help is much appreciated!

I have criteria horizontal and vertical. e.g I need to know what the target is for Sales Rep B, customer GG in the month May.
A
Sales rep Customer Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
A BB 10 20 30 40 50 60 70 80 90 100 110 120
A CC 10 20 30 40 50 60 70 80 90 100 110 120
A DD 10 20 30 40 50 60 70 80 90 100 110 120
A EE 10 20 30 40 50 60 70 80 90 100 110 120
B FF 10 20 30 40 50 60 70 80 90 100 110 120
B GG 10 20 30 40 50 60 70 80 90 100 110 120
B HH 10 20 30 40 50 60 70 80 90 100 110 120
B JJ 10 20 30 40 50 60 70 80 90 100 110 120
C KK 10 20 30 40 50 60 70 80 90 100 110 120
C LL 10 20 30 40 50 60 70 80 90 100 110 120
C MM 10 20 30 40 50 60 70 80 90 100 110 120
C NN 10 20 30 40 50 60 70 80 90 100 110 120


Sales rep Customer Month Sum
B GG May ?


Thank you thank you!

You have unique Customer and Months, so enough for

Formula:

Please Login or Register  to view this content.

where B16 is a DataValidation List of Customer and C16 is DataValidation List of Months.

Hi,

Thanks for your quick response.


I have attached the file because i'm not following what you are doing. could you put the formula in working E17?


Thank you!

see attachment

@ popipipo

Do you think I need your example?

Great!!!!!

Thank you all so much.

Glad to help

If problem is resolved it's always a good practice to click on Add Reputation star to person(s) who helped you (anyone else can do it also) and mark thread as Solved. Thanks


.Another example

@popipipo
No problem

@ Play1234
Thanks for the feedback