Sumif- A very important formula in advance excel
- This topic is empty.
-
Posts
-
shreyanshh
Use- suppose if we want to sum a given set of data only if a certain criteria is matched, we use this function. Arguments of this function are- range, criteria and sum range
Range – it is the column in which we will check if our criteria is matched or not.
Criteria – this is the criteria that has to be matched for finding the sum. The criteria can be a text, a logical operator like( >,=, <), or a number. If the criteria contains text or logical operator, it has to be necessarily written within double quotes. Sum range – it is range of data whose sum we would like to find if the given criteria is matched. After the formula is written with all its arguments, press tab to get answer. Suppose if we have to check for more than one criteria, we use sumifs function which has a bit different arguments . It is a very useful function. Sent from my S6s using
Actuarial Info mobile app
- You must be logged in to reply to this topic.