negative entries
• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

Forum home » Delegate support and help forum » » Negative entries

# Negative entries

Resolved · Low Priority · Version 2007

Konstantin has attended:
Excel Introduction course

### Negative entries

How does one make Excel sum up only positive values and automatically ignore negative entries in a simple summation?

### RE: Negative entries

Dear Konstantin

Thank you for attending Excel Introduction Course. I hope you enjoyed the course and that you benefited from it.

It is possible to calculate only the positive figures. We cover a function called SUMIF in Advanced level that can resolve this query.

The syntax of a SUMIF is :

=SUMIF(Range,Criteria,Sum_range)

I'll provide you with a simple example as follows:

A B C

1 10

2 -20

3 -5

4 5

5 =Sumif(A1:A4,">0",A1:A4)

This should give you a result of 15 on cell A5 because it will not count any negative numbers.

NB: If you are using the Function dialog box then you do not need to put >0 in Quotation marks (" ").

I hope this has helped you in resolving your query.

I would request you to mark the post as resolved!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the \$dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips