Quinn NelsonMar 3, 2023

Who’s halfway decent at Excel and can help me out?

Column A - SKU name
Column B - Items sold in transaction

For example,

BLUE BOAT 2
BLUE BOAT 1
BLUE BOAT 1
TEAL SHOE 1
TEAL SHOE 3

Right now I’m doing =SUM(B1:B3) to calculate how many blue boats sold. This is dumb and forces me to do it manually for every SKU. What is the smart way?

Show threadAlex PerleiMar 3, 2023
@snazzyq SUMIF or SUMIFS. Feels like magic the first time you use it for a real task.
Show threadAlex Perlei

@snazzyq more specifically:

=SUMIF(A1:A5, “BLUE BOAT”, B1:B5)

Mar 4, 2023 at 12:01amIvory for iOS