Having some difficulty with summing cells

  • Thread starter Thread starter Ryanjoseph42
  • Start date Start date
R

Ryanjoseph42

I have a spreadsheet in which I have one column with values, and another
that either has a check symbol or nothing at all. The issue is that I am
trying to sum the values from the value column that pertains to the rows
where there are check sybols in the check column.

Does anyone know how to do this?
 
In another column use this formula

If your value is in col A and the check box in col B put this formula in col C

=if(b1="your symbol",A1," ")
 
If your values are in A1:A0 and your check symbols are in B1:B10 then
=SUMIF(B1:B10,"Your_Check_Symbol_Here",A1:A10) sums for check symbols in
B1:B10
or
=SUMIF(B1:B10,"<>"&"",A1:A10) sums for B1:B10 not blank

Tyro
 
You must log in or register to reply here.

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

Having Blank Cells, etc. ? 1
Sum / Lookup 9
Filtering with SUMIFS 1
Summing rows using formulas with variables 1
Excel formula, sum the value cell and if empty cell left blank 0
Numbers showing Up Centered in Cell ? 1
summing part of data range 3
series of sums in a long spreadsheet 1

Back
Top