Hi There,

I have a few questions:

EXAMPLE

A B C D
REP 1.00 Jan 1,2009 Approved
SAK 1.00 Jan 2,2009 Approved
HW 1.00 Jan 4,2009 Denied
HW 1.00 Feb 1,2009 Denied
ITP 1.00 Feb 2,2009 Approved

QUESTION 1
I want to be able to compare "D" and "A" and add "B" for a result, is this possible?
So, if REP = approved, add all "approved value in B", result = 1.00
So, uf HW = denied, add all "denied value in B", result = 2.00

QUESTION 2
I want to sum up "B" by the January Month in "C", is it possible with the date broken out the way it is?

If someone could help me with these formula's I'd really appreciate it.

Thanks,
Meagan

I can include my file if necesary