EXCE L L TRAIN N ING MA A NUAL Form mula  =IND DEX('SOUR RCE-1'!$D$2: :$D$22,MAT TCH('TARGE ET-1'!D5,'SO OURCE-1'!$C C$2:$C$22,0) ))  6. C COUNT T FUNC CTIONS S  Excel's  C purpose  data ran g ount Funct such as the  e. ions allow  y number of c you to coun cells contain n t up the n u n ing number umber of ce r  values or t h e lls being us he number o s ed for a sp of blank cell s ecific s in a The funct tion ignores   empty cells   and those th hat contain t text data.  If a num updated t mber is later to include th r added to  his new data an empty c a.  cell the fun nction will b be automati ically  Note: dat es, times, fu nctions, and d formulas a re stored as   numbers in   Excel.   $_{They wil}$ selected r ll, therefore range. e, be count ted by the e COUNT  function if  present in n the  6.1 HO OW TO AP PPLY FO RMULA  6.1.1 C COUNT  =C COUNT(VAL LUE1,VALU UE2,…)  Page 16 GLYPH<g3>