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
Download Full PDF and Excel Example Files: Click Here
Register My Special Course: វគ្គ ១០១ រូបមន្ត Excel
0 comments: