Thread: SUM formula for data from one column when another is populated
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default 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.


Reply With QuoteReply With Quote