Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summing Cells with #N/A | Excel Worksheet Functions | |||
Color Cells Summing | Excel Worksheet Functions | |||
Difficulty linking cells in Excel 2003 | Excel Worksheet Functions | |||
Summing of Two cells does not sum!! | Excel Discussion (Misc queries) | |||
Summing some cells | Excel Worksheet Functions |