I am trying to do the follwing but seem to be having problems with the last part.
I have a spreadsheet which is populated via links to another spreadsheet. I have the following so far:
=SUMPRODUCT((capcon!$E2:$E13000=$B3)*(capcon!$C2:$C13000=$A3)*(capcon!$F2:$F13000=GATEB))
This gives a result but I also need to add another criteria that looks at column G:G on the capcon sheet and determines those with the above criteria but also between two dates specified in two named cells (Today and Today30) I actualy nned to determine dates greater than Today and less than Today30. Column G:G is date formated.
I have a spreadsheet which is populated via links to another spreadsheet. I have the following so far:
=SUMPRODUCT((capcon!$E2:$E13000=$B3)*(capcon!$C2:$C13000=$A3)*(capcon!$F2:$F13000=GATEB))
This gives a result but I also need to add another criteria that looks at column G:G on the capcon sheet and determines those with the above criteria but also between two dates specified in two named cells (Today and Today30) I actualy nned to determine dates greater than Today and less than Today30. Column G:G is date formated.