Forum Discussion

bneely316's avatar
bneely316
Copper Contributor
Aug 07, 2020

IFS Question

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.  

Resources