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

  • Thread starter Thread starter Scott
  • Start date Start date
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.
 
Back
Top