View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michelle Michelle is offline
external usenet poster
 
Posts: 11
Default ANOTHER URGENT QUESTION - Sums and Ifs

f
h j
STATUS NAT OF CASE RSV

2 Open - Active EEOC
1000
3 Open - Probable EEOC 1000
4 Open - Active GVT Invest
1000
5 Open - Probable Gvt Invest
2000

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

Open - Active (Non - Government Investigations):
Open - Active (Government Investigations):
Open - Probable: