Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Follow up question about consolidating dups and sums | Excel Worksheet Functions | |||
Urgent question regarding LIST | Excel Discussion (Misc queries) | |||
Pivot question about sums | Excel Discussion (Misc queries) | |||
NEWSGROUP QUESTION URGENT | Excel Worksheet Functions | |||
validation question, urgent pls help | Excel Discussion (Misc queries) |