PC Review


Reply
Thread Tools Rate Thread

ANOTHER URGENT QUESTION - Sums and Ifs

 
 
Michelle
Guest
Posts: n/a
 
      5th Jan 2012
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:
 
Reply With Quote
 
 
 
 
isabelle
Guest
Posts: n/a
 
      6th Jan 2012
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:

 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      6th Jan 2012
On Jan 5, 5:55*pm, Michelle <craggerg...@gmail.com> 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.
 
Reply With Quote
 
Michelle
Guest
Posts: n/a
 
      6th Jan 2012
On Jan 6, 7:09*am, Don Guillett <dguille...@gmail.com> wrote:
> On Jan 5, 5:55*pm, Michelle <craggerg...@gmail.com> 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.
 
Reply With Quote
 
Michelle
Guest
Posts: n/a
 
      6th Jan 2012
On Jan 6, 7:09*am, Don Guillett <dguille...@gmail.com> wrote:
> On Jan 5, 5:55*pm, Michelle <craggerg...@gmail.com> 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!!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:33 AM.