| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum of cells that correspond to non empty cells
hello,
if i have two columns and i want to sum the values in each cell in each column that correspond to a nonempty cell in the other column what should i do? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum of cells that correspond to non empty cells
On Sun, 9 Mar 2008 00:04:00 -0800, nada
wrote: hello, if i have two columns and i want to sum the values in each cell in each column that correspond to a nonempty cell in the other column what should i do? One of serveral possibilities is to use the SUMPRODUCT function =SUMPRODUCT(- - (A1:A100<""), B1:B100) will sum the data for the first 100 rows of column B where the corresponding cell i column A is non empty Hope this helps. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum of cells that correspond to non empty cells
You could do this
=SUMPRODUCT((ISBLANK(A1:A30))*(B1:B30)) or this depending on your definition of blank =SUMPRODUCT((A1:A30="")*(B1:B30)) Mike "nada" wrote: hello, if i have two columns and i want to sum the values in each cell in each column that correspond to a nonempty cell in the other column what should i do? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum of cells that correspond to non empty cells
have I misread your post you want to sum for non empty cells
=SUMPRODUCT((A1:A30<"")*(B1:B30)) Mike "nada" wrote: hello, if i have two columns and i want to sum the values in each cell in each column that correspond to a nonempty cell in the other column what should i do? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum of cells that correspond to non empty cells
=SUMIF(A1:A100,"<",B1:B100)
"nada" wrote: hello, if i have two columns and i want to sum the values in each cell in each column that correspond to a nonempty cell in the other column what should i do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| skip cells with zero values in chart (cells not empty) | Charts and Charting in Excel | |||
| Linking cells into empty cells in another worksheet | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Linear Mode
