The SUMIF function can quickly add up all values in a dataset that matches certain criteria👍
SUMIF has three parts:
1. Select the range where the items you want to count are found
2. Select the criteria we’re looking - here data relating to the client name
3. Select the data that you want to add up - here select the spend column
#exceltips #excelformarketers #SUMIF
——————————————————————————
Tired of long, boring online courses? Let's learn the Excel Essential Skills in 30 mins. It's short and simple, no bluff.
learn.vanna.com/?utm=yt
コメント