Flagging cell entries in a column to add to a subtotal.
 

Anyone know how to do this?

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?

Flagging cell entries in a column to add to a subtotal.
 

http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu200777