View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Having some difficulty with summing cells

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


"Ryanjoseph42" wrote in message
...
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?