

Excel If Statement 


CountIF 

Counting markets per
parent 
 =COUNTIF(C1:C17,"=Gannett")


 For instance, how many markets at Gannett, McClatchy, and Tribune are on
the list?



CountIF 

Counting markets above
meeting certain number of sales 


 For instance, how many markets sold at least 50 listings?



CountIF 


 =IF('Sandbox Raw Data'!N7>0,'Sandbox Raw Data'!C7,"")


 This formula will display markets assigned to a specific sales rep, for
instance, Katie



Difference in Real
Numbers, When Given a Percentage 





 This formula is used when we know a value for September,
and we know the percentage change from a previous month (such as September of the previous
year)



Forecast
increase/decrease by a fixed percentage 



 A1+(A1*.04)
 or
 A1+(A1*B12)


 another way is to assign the fixed percentage to a given
cell, such as B12, in this example



Given Pct, what is the raw number 





 This formula is used when we know
the current numbers, and we are given the percentage change from a
year ago, but do not have the actual numbers from a year ago. This
formula lets us calculate where we were one year ago.



Nested IF statements,
with text included 



 =IF((AND(B2="West",C2>10000)),"Senior","Junior")


 another way is to assign the fixed percentage to a given
cell, such as B12, in this example



Percentage
Change 

Percentage
Change, from Last Month to This Month 
 (B7/B8)/1
 If March is B7
AND
February is B8


 This formula reports the percentage change, from one month to another



Raw
Change 

Raw
Change, from Last Month to This Month 
 B7/B8
If March is B7
AND
February is B8


 This formula reports the absolute numerical change, from one month to
another



