SUM formula for data from one column when another is populated
 

I would like help creating a formula that when data is populated in
one column, it pulls the number from another column and sums it in a
cell at the bottom of the worksheet.

SUM formula for data from one column when another is populated
 

Maybe

=SUMPRODUCT(--(ISBLANK(A2:A10)=FALSE),(B2:B10))

HTH,
Barb Reinhardt

"Michael" wrote:

I would like help creating a formula that when data is populated in
one column, it pulls the number from another column and sums it in a
cell at the bottom of the worksheet.

SUM formula for data from one column when another is populated
 

On Jun 27, 9:46 pm, Barb Reinhardt
wrote:
Maybe

=SUMPRODUCT(--(ISBLANK(A2:A10)=FALSE),(B2:B10))

HTH,
Barb Reinhardt



"Michael" wrote:
I would like help creating a formula that when data is populated in
one column, it pulls the number from another column and sums it in a
cell at the bottom of the worksheet.- Hide quoted text -

- Show quoted text -

I received an error message. Let me try to explain further...For
example; I have one column (Y) blank (y2:y142), then I have one column
(I) with random numbers in it (I2:I142). When a cell is populated in
column Y, I would like the formula to go to column I grab the number
in the corresponding row and sum in a cell at the bottom of the sheet.
Is there a way that I can do that? I am just a bit confused on how to
approach it. Thanks for the help!