IFS Question

%3CLINGO-SUB%20id%3D%22lingo-sub-1572098%22%20slang%3D%22en-US%22%3EIFS%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572098%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20found%20out%20about%20IFS%20today%20so%20I%20am%20probably%20way%20out%20of%20my%20league.%26nbsp%3B%20I%20am%20doing%20an%20injury%20tracking%20spread%20sheet%20that%20has%20the%20injuries%20in%209%20different%20categories%3A%26nbsp%3B%3CSPAN%3ESprain%2FStrain%2C%20Struck%20By%2C%20Slips%2C%20Trips%2C%20Falls%2C%20Other%2C%20Debris%20in%20eye%2C%20Cut%2FAbrasion%2C%20Shock.%20each%20time%20an%20injury%20occurs%20I%20want%20to%20%2B1%20to%20the%20totals%20column%20which%20will%20automatically%20adjust%20my%20graph%20on%20the%20second%20page.%26nbsp%3B%20the%20n%20column%20has%20the%20injury%20classification.%20down%20at%20the%20bottom%20I%20made%20a%20totals%20section.%20%3DIFS(N2%3D%22Strains%2FSprains%2C%24O%2416%3DSUM(%24016%2B1)%2CN2%3D%22Struck%20By%22%2C%24O%2417%3Dsum(%240%2417%2B1)%20etc.%20Anybody%20help%20would%20be%20appreciated.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1572098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1572140%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1572140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F752059%22%20target%3D%22_blank%22%3E%40bneely316%3C%2FA%3E%26nbsp%3B%2C%20I'd%20suggest%20using%20a%20COUNTIF%20or%20COUNTIFS%20instead%20of%20IFS.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.  

1 Reply

@bneely316 , I'd suggest using a COUNTIF or COUNTIFS instead of IFS. See attached.