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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
