sum of cells that correspond to non empty cells

  • Thread starter Thread starter nada
  • Start date Start date
N

nada

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?
 
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?
Click to expand...

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.
 
You could do this

=SUMPRODUCT((ISBLANK(A1:A30))*(B1:B30))

or this depending on your definition of blank
=SUMPRODUCT((A1:A30="")*(B1:B30))

Mike
 
have I misread your post you want to sum for non empty cells

=SUMPRODUCT((A1:A30<>"")*(B1:B30))

Mike
 
Back
Top