category
value
formula
SUMIF
cat1
2
sumif(A1:A5, "cat1", B1:B5) =
sumif(A1:A5, "cat1", B1:B5)
cat13
4
sumif(B1:B5, ">5") =
sumif(B1:B5, ">5")
cat1
6
sum(B1:B3)
cat2
8
cat1
10