Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two formulas in one cell
Unfortunately, the previous formula was not helpful.
I am trying to make cell V7 show both H and MO... Cell A5 shows "H" 3, A6 shows "H" 1 , and Cell A7 shows "MO" 1 and Cell A8 shows "MO" 1. Would I be able to show both H and MO in cell V7 and the totals in cell V8? My current formula is: =SUMIF(B8:O8,"H",B9:O9). Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS. | Excel Discussion (Misc queries) | |||
How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
change cell value greater than another cell value using formulas | Excel Worksheet Functions |