Sum function

D

dannyboy8

If i have a row of positive and negative #s, and I want to sum up this row,
but only include the positive #s in the sum, how would I go about doing this?
 
B

Bill Eckert

-- If I have several columns that I wish to calculate and a text word is
used in one column, what formula can I use without getting an error.
Bill Eckert
 
G

Gord Dibben

What type of calculation?

A simple SUM will ignore text.


Gord Dibben MS Excel MVP
 

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

Cumulative formula for word table 0
Changing row background from external program 0
Program buttons to create a word document 0
sum function 1
sum function 3
How to display the merge function "url" of a picture? 0
Vlookup? 2
How do I select a range? 2

Top