I have a formula below that retrieves data based on selection but for some reason the column 2014 Oct is multiplying the data. All other data retrieval columns are pulling correctly. Can someone tell me what I am missing.
The file is attached. The formula is located on the calculation tab and the data tab is called " Dashboard Data". I have included the excel file.
=IF(AND($F$5<>"SOUTHEAST",$F$5<>"NORTHEAST",$F$5<>"WEST"),SUMPRODUCT((DATA_TBL)*(DATA_HEADER=H$7)*(DSM_LIST=$F$5)*(METRIC_LIST=$F8)*1),SUMPRODUCT((DATA_TBL)*(DATA_HEADER=H$7)*(METRIC_LIST=$F8)*1))
Thank you.
The file is attached. The formula is located on the calculation tab and the data tab is called " Dashboard Data". I have included the excel file.
=IF(AND($F$5<>"SOUTHEAST",$F$5<>"NORTHEAST",$F$5<>"WEST"),SUMPRODUCT((DATA_TBL)*(DATA_HEADER=H$7)*(DSM_LIST=$F$5)*(METRIC_LIST=$F8)*1),SUMPRODUCT((DATA_TBL)*(DATA_HEADER=H$7)*(METRIC_LIST=$F8)*1))
Thank you.
