I have an Excel with 3 sheets (operating system in English):
On the DATA sheet I have data correlation tables. To know what month is month 1 I have this: - Cell D2 = 1 - Cell D3 = January
On the DATA ENTRY page I have this: - In cell I1 I enter a date: "10/01/2018" - In cell K1 I put the formula = MONTH (I81), and I get the month number (1) - In cell K1, with VLOOKUP I go to the "Data" sheet, I get the value "January" for month 1 - In cell X1, I type the product type: "Dental" - In cell AB1, I put sales in Euros: 300
On the SALES sheet I want to know the sales of the "Dental" product in the month of January. I'm doing it with SUMPRODUCT but it gives me zero. The formula I put is this: = SUMPRODUCT (('DATA ENTRY'! AJ4: AJ10000 = Data! D3) ('DATA ENTRY'! X4: X10000 = Data! I5) ('DATA ENTRY' ! AB4: AB10000))
- Data! D3 is "January"
- Data! I5 is "Dental"
I've tried putting ";" instead of "*" and nothing. I have tried to set the values "January" and "Dental" and nothing.
Can you help me?