I have a very large file that when you select the month and department all of the data in the table changes based on that criteria. And the sumproduct formula shown below no longer works because it only worked for the first department (1 out of 15). How could I make this formula work to say if(month & if(department, then sumproduct """"?
The formula used to work because it only had to sum up the column that was between two dates. Now I have a file with 4575 rows that concatenate the date, department and subdepartment. Can excel figure out all of this information in one formula or do I need a work around?
SUMPRODUCT(--('AAM Detail'!$B$4:$B$39>='AAM Payor Mix Dashboard'!$G$4),--('AAM Detail'!$B$4:$B$39<='AAM Payor Mix Dashboard'!$D$5),'AAM Detail'!$B$4:$B$39)
The formula used to work because it only had to sum up the column that was between two dates. Now I have a file with 4575 rows that concatenate the date, department and subdepartment. Can excel figure out all of this information in one formula or do I need a work around?
SUMPRODUCT(--('AAM Detail'!$B$4:$B$39>='AAM Payor Mix Dashboard'!$G$4),--('AAM Detail'!$B$4:$B$39<='AAM Payor Mix Dashboard'!$D$5),'AAM Detail'!$B$4:$B$39)