sumproduct questions

[Kmitchell]

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)

 

[venkat1926]

sorry for the off the cufff suggestion

you convert the concatenated data into "text to columns " and work on it.
If you have already tried this ignore this message