If you want find total value base on certain condition, you can use SUMIF. SUMIF help you to calculate sum of value with criteria like "Male", Date, any value.
SUMIF Formula
=SUMIF(Range, Criteria, [sum_range])
◾ Range: Required, set of value or cells◾ Criteria: Required, sum base on condition
◾ [sum_range]: optional, range to sum
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEZgrXLxQTDt3DRQ-Rg5GQihP2aph0vDTrZwBoYsT1D9MQM8PvTzzl83heR7PdfEA-1yVpt_ob-aIXLGvHEFSmUrGkbv5mr6OfyXcXpil41fUfs_DoYgbF1_vrejEaPljojusSa1KXWk4G8wjf2eCUKLHx0EZ-6aa-8iJh11rR10fas_OpV88QYleKHA/s1600/%E1%9E%9A%E1%9F%80%E1%9E%93%20Excel%20Khmer%20-%20SUMIF%20formula%20in%20Excel%20speak%20Khmer.jpg)
Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel
0 comments: