SUMIF, SUMIFS, COUNTIF, COUNTIFS

쿠잉쿠잉 2023. 6. 14. 13:02

Function	Example
=SUMIF(range, criteria, [sum_range])	=SUMIF(A1:A9, "Fuel", B1:B9)
=SUMIFS(sum_range, range1, value1, [range2, value2, ...])	=SUMIFS(B1:B9, A1:A9, "Fuel", C1:C9, "12/15/20")
=COUNTIF(range, value)	=COUNTIF(A1:A9, "Food")
=COUNTIFS(range1, value1, [range2, value2, ...])	=COUNTIFS(A1:A9, "Coffee", C1:C9, "12/15/2020")