Hi,
Let's say you want to summarize column A from row 1 to 100 use

=sumproduct(--(A1:A1000),A1:A100)

"dannyboy8" wrote:

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?