D dannyboy8 Jun 30, 2009 #1 if I have a row of #s and I want the sum to include only the positive #s, what kind of formula could I write to accomplish this?
if I have a row of #s and I want the sum to include only the positive #s, what kind of formula could I write to accomplish this?
E Eduardo Jun 30, 2009 #2 Hi, Let's say you want to summarize column A from row 1 to 100 use =sumproduct(--(A1:A100>0),A1:A100)
Hi, Let's say you want to summarize column A from row 1 to 100 use =sumproduct(--(A1:A100>0),A1:A100)
R Rick Rothstein Jun 30, 2009 #4 I'm not sure why you have posted this question again... I responded to your first posting that asked this question 6 days ago. My answer then was this: Change the range to suit your actual setup... =SUMIF(A1:Z1,">0")
I'm not sure why you have posted this question again... I responded to your first posting that asked this question 6 days ago. My answer then was this: Change the range to suit your actual setup... =SUMIF(A1:Z1,">0")
