Formula - if low=1; if med=2; if hi=3

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi- I have a column of data that has text of either L, M, or H. I am trying
to summarize totals from each category. I have a separate column where I
have manually coded each low as 1, med as 2, and hi as 3.

The "new" "open" and "closed" is calculated by the following formula:
=SUM(IF((F$2:F$41="New")*(G$2:G$41="L"),H$2:H$41))
which is why I think I need to return a value for the L, M, and H but
perhaps there is a better formula to use?

LOW new -
open 20.00
closed 7.00
MED new -
open 11.00
closed 2.00
HI new -
open -
closed -

Any recommendations? Thanks for your help!
 
Where does the "open" and "closed" come into the calculation?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Hi- I have a column of data that has text of either L, M, or H. I am trying
to summarize totals from each category. I have a separate column where I
have manually coded each low as 1, med as 2, and hi as 3.

The "new" "open" and "closed" is calculated by the following formula:
=SUM(IF((F$2:F$41="New")*(G$2:G$41="L"),H$2:H$41))
which is why I think I need to return a value for the L, M, and H but
perhaps there is a better formula to use?

LOW new -
open 20.00
closed 7.00
MED new -
open 11.00
closed 2.00
HI new -
open -
closed -

Any recommendations? Thanks for your help!
 
You count the L with

=COUNTIF(G$2:G$41,"L")

but I don't get why you need it. Your formula works okay?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Take a look at the Data > SubTotals feature.........it should do what you
want, and produce a nice looking report.......

Vaya con Dios,
Chuck, CABGx3
 
The formula works because I've manually keyed it in a value for each
instance. Is there a formula that would do that automatically?

Thank you for your response -
 
I am trying to track issue resolution, including level of priority (L,M,H)
and status (open/closed).

Thanks,
Paula
 
Back
Top