I am so sorry to bother everyone, but would love it if someone could
contunie to help me with these formulas. I made the initial inquiry
below, and Isaeblle provided me with formulas (so appreciate the
help), but they are not working in my spreadsheet. I am not an excel
person at all - a coworker was terminated, and my boss has asked me to
help her put calcuations into a spreadsheet that is due to accounting
this afternoon. I was referred to this site as a possible solution. I
am using Excel 07.

=SUMPRODUCT(--(A2:A20="Open - Active")*(B2:B20<"Gvt
Invest")*(C2:C120))


=SUMPRODUCT(--(A2:A20="Open - Active")*(B2:B20="Gvt
Invest")*(C2:C120))


=SUMPRODUCT(--(A2:A20="Open - Probable")*(C2:C120))

See example and explanation below:

STATUS NAT OF CASE RSV

Open - Active EEOC 1000
Open - Probable EEOC 1000
Open - Active GVT Invest 1000
Open - Probable Gvt Invest 2000


How do I create formulas that will capture the subtotals totals for J
for:

Open - Active (Non - Government Investigations): Total all in
spreadsheet that are Open - Active but not classified as Gvt invest.
Total should equal 1000

Open - Active (Government Investigations): Total all in spreadsheet
that are Open - Active but classified as Gvt invest. only. Total
should equal 1000

Open - Probable: Totals all in spreadsheet that are Open - Probable.
Total should equal 3000