Excel Magic Trick #203: SUMIF function formula 21 Examples
See methods for summing with criteria: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to an amount, values form a specific sales Representative, values that have no Sales Representative, the use of wildcards for criteria, and more!
Learn about the syntax that the SUMIF function uses and see different methods to achieve the same goal.
I’ll be watching, thanks
Dear trunkhustler ,
I’ll make a video and post it on Friday.
–excelisfun
I want to make a sheet that takes subtract 20% from an artists sales if its a Gold account, 2.9% off if its a Platinum account and nothing if its a Diamond account.
I am so new to this… can you guide me to one of your tutorials that teaches this.
Dear ka4irga ,
I am glad that the videos help!!
–excelisfun
Thanks doude! I will watching your tutorials all night and from morning go to exam ! ;]