Formula required for SUMIFS with two criteria over multiple columns and rows

Hi there,

Can you please help? Tried a number of solutions already on this site and others but haven't been able to fix it myself yet. Screenshots below, but example sheet attached!

http://i.imgur.com/gyYo3xi.png this shows how my data looks when it is downloaded (notice how it only shows the dates that have happened so far, plus a total column). The total column isn't necessary for this task, and if there is no data for a particular date then that date wont show.

http://i.imgur.com/sEUED8e.png this shows a formula I have added in column A to combine the data in column C and column D (the download doesn't always show what column D is for, so my formula in column A also corrects this).

http://i.imgur.com/85OCS44.png this is the format I need and where the formulas will go to pull out the relevant data. For example, cell C3 should result 4 as that is the sum for the number of patients admitted as "DPU - Day Only Patients" on the 1/06/17. I would then need to copy this formula across to cover all dates and down to capture all wards. If there is no data then it should show a 0 (like an ordinary SUMIF formula).

Thanks in advance for any help.

Cheers

Worked great, thanks! I made a couple adjustments (see below) just to extend it to cover additional rows and columns for future dates and removed on of the $ in the last reference so it could be copied across. Thanks for your help, nflsales!

=IFERROR(SUMIFS(INDEX('DATA DOWNLOAD'!$F$7:$S$999,,MATCH(C$2,'DATA DOWNLOAD'!$F$3:$BA$3,0)),'DATA DOWNLOAD'!$A$7:$A$999,$A3),0)

Originally Posted by nflsales

you need to change 'DATA DOWNLOAD'!$F$7:$S$999 also as 'DATA DOWNLOAD'!$F$7:$BA$999

Sorry, not 100% what you mean. How should the formula read?