SUM formula for data from one column when another is populated

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

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.
 
Maybe

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

HTH,
Barb Reinhardt
 
Maybe

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

HTH,
Barb Reinhardt





- Show quoted text -
Click to expand...

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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Reference Separate Sheet for Formula 2
Conditional Formatting with VBA 4
Multiple SUM's in a column 15
Better Understanding 4
Dynamic add formula 2
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 1
Conditional listbox cell populating 4

Back
Top