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:

ANOTHER URGENT QUESTION - Sums and Ifs
 

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 :

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

ANOTHER URGENT QUESTION - Sums and Ifs
 

On Jan 5, 5:55*pm, Michelle wrote:
* * * * 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.

ANOTHER URGENT QUESTION - Sums and Ifs
 

On Jan 6, 7:09*am, Don Guillett wrote:
On Jan 5, 5:55*pm, Michelle wrote:





* * * * 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.- 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.

ANOTHER URGENT QUESTION - Sums and Ifs
 

On Jan 6, 7:09*am, Don Guillett wrote:
On Jan 5, 5:55*pm, Michelle wrote:





* * * * 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.- 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!!