SUMIF with sections of data
I have 2 columns of data and each section is separated by a blank line. Each
section doesn't have the same amount of rows. Is there some way for a user to
hit a button (macro?) that will sum each section?
PRODUCT A $1
PRODUCT A $100
PRODUCT B $50
PRODUCT B $20
PRODUCT A $5000
PRODUCT A $6000
PRODUCT B $50
PRODUCT B $20
PRODUCT B $10
PRODUCT B $2
|