Just found out about IFS today so I am probably way out of my league. I am doing an injury tracking spread sheet that has the injuries in 9 different categories: Sprain/Strain, Struck By, Slips, Trips, Falls, Other, Debris in eye, Cut/Abrasion, Shock. each time an injury occurs I want to +1 to the totals column which will automatically adjust my graph on the second page. the n column has the injury classification. down at the bottom I made a totals section. =IFS(N2="Strains/Sprains,$O$16=SUM($016+1),N2="Struck By",$O$17=sum($0$17+1) etc. Anybody help would be appreciated.