'ignore' cells in calculating?

  • Thread starter Thread starter Rick C.
  • Start date Start date
R

Rick C.

I'm new to Excel. I have a simple column of numbers I'm summing. Is
there a way I can flag selected cells in this column for Excel to ignore
in its calculation? I'd occasionally like to sum ~all~ the cells in the
column, but at other times to sum only those I've not flagged as
'ignore'. Thanks.
 
You could set up a column beside your current column which
would contain TRUE or FALSE (either manually entered, or
using a formula). Then use the SUMIF function. For
example if you had this situation, and used =SUMIF
(B1:B7,TRUE,A1:A7) the result would be 57.

A B
5 True
6 False
7 True
8 False
10 True
35 True
13 False
 
.... or if there is a hard and fast rule in the data for what gets ignored,
such as say anything less than 10, you could test that
=SUMIF(A1:A7,">=10",A1:A7)
 
Back
Top