ANOTHER URGENT QUESTION - Sums and Ifs

[Michelle]

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:

 

[isabelle]

hi Michelle,

=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))


--
isabelle



Le 2012-01-05 18:55, Michelle a écrit :

 

[Don Guillett]

        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:

Michelle, It is a "turn off" for many when you say URGENT!! All
requests are treated as urgent.

 

[Michelle]

Michelle, It is a "turn off" for many when you say URGENT!! All
requests are treated as urgent.- Hide quoted text -

- Show quoted text -

Got it! My sincere apologies - I didnt mean to cause any disrespect. I
didnt know. In any event, the formulas arent working as I initially
thought. I was going to ask for more help, but understand requests
should be handled in order of priority. Thank you for the education. I
will be sure to be more minduful of other requests that have been made
it the future.

 

[Michelle]

Michelle, It is a "turn off" for many when you say URGENT!! All
requests are treated as urgent.- Hide quoted text -

- Show quoted text -

I am sorry! I didnt know that. Thank you for the education! Will be
sure to be mindful of that next time!!