Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula - if low=1; if med=2; if hi=3
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula - if low=1; if med=2; if hi=3
Where does the "open" and "closed" come into the calculation?
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "PTimo" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula - if low=1; if med=2; if hi=3
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) "PTimo" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula - if low=1; if med=2; if hi=3
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 "PTimo" wrote: 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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula - if low=1; if med=2; if hi=3
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 - "Bob Phillips" wrote: 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) "PTimo" wrote in message ... 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! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula - if low=1; if med=2; if hi=3
I am trying to track issue resolution, including level of priority (L,M,H)
and status (open/closed). Thanks, Paula "RagDyeR" wrote: Where does the "open" and "closed" come into the calculation? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "PTimo" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |