negative entries

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Negative entries

Negative entries

resolvedResolved · 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:

See also:

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.


 

Excel tip:

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


Server loaded in 0.08 secs.