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

M

Martin Fishlock

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.
 

Ask a Question

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.

Ask a Question

Similar Threads

How do I create a set of words that are flagged? 0
Office365 Family + TXT or MX Domain 0
calculating subtotals for sequential blank cells in 1 column 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Problem with subtotal function 0
Subtotal of values in cells containing formula 1
Subtotal 3
Calculations of Cell after Autofiltering 0

Top