It is an excel SUMIF function returns the sum of cells that
meet a single condition. Criteria can be functional to dates, numbers, and
text. The SUMIF function supports rational operators (>,<,<>,=) and
wildcards (*,?) for partial matching.it is sum conditional function formula of
excel it is call SUMIF function.
Notes :- It is Sum numbers in a range that meet supplied criteria
the sum of values supplied.
It is SUMIF function returns the sum of cells in a range
that meet a single condition. The first disagreement is the range to apply
criteria to, the second disagreement is the actual criteria, and the last
argument is the range containing values to sum. SUMIF supports logical
operators (>,<,<>,=) and wildcards (*,?) for partial matching. If
you need to apply more than one criteria, it is use SUMIFS function.
Syntax :- =SUMIF (range, criteria, [sum_range]) Enter
Example :-=SUMIF((G6:G16,K6,I6:I16) Enter
Example :- =SUMIF(I6:I15,">7500") Enter
Example :- = SUMIF(H6:H15,K6,I6:I15) Enter
Example :- =SUMIF(I6:I15," "&L5) Enter
Example :- =SUMIF(I6:I15,">"&L5) Enter
No comments:
Post a Comment
if you have any doubt let me known will
give suggestion in this site
Thank you so much