98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Cycling through Absoulte cell referencesIf 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. |