Adding with a date range

[#1]

Hi,

given the data below, I'd like to sum up the Cost for each FGC only if date is in a certain range.  Any help would be appreciated. Thank.

FGC	Cost	Date
A1	10	09/2012
A1	12	10/2012
A1	8	11/2012
A1	9	02/2013
A1	1	05/2013
B1	13	05/2012
B1	5	08/2012
B1	35	10/2012
B1	34	04/2013
C1	77	01/2012
C1	4	01/2013
C1	23	02/2012

I'd like to have: sum of cost per each FGC for a given date range (let's say date < 02/2013)

[#2]

It really depends on what you are trying to achieve.  If you want the user to define the range, check into variables or a master calendar.  Another option is set analysis.  See attached for an example.

[#3]

Hi!

take a look!

[#4]

I'm trying to get the sum of FGC so for A1 I'm looking for 30 because 10+12+8=30 (filtering on date < 02/2013).