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

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.