Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flagging cell entries in a column to add to a subtotal.
Anyone know how to do this?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flagging cell entries in a column to add to a subtotal.
Scott:
One way is to have a colum (say column e) and we can call it flag and in the rows where you want the number summed you type x, 1, true or yes and you do this for all the numbers that you want summed. Then you use sumif(e1:e10,1,a1:a10) in a11 to sum the above. -- Hope this helps Martin Fishlock, Bangkok, Thailand www.nyfconsultants.com Please do not forget to rate this reply. "Scott" wrote: Anyone know how to do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Flagging cell entries in a column to add to a subtotal.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountA, Subtotal and "move to the first cell in the next column" | Excel Worksheet Functions | |||
CountA, Subtotal and "move to the first cell in the next column" | Excel Discussion (Misc queries) | |||
flagging duplicates within same column of data | New Users to Excel | |||
Finding duplicate cell entries in a column of data | Excel Discussion (Misc queries) | |||
Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) |