u/Advanced-Jelly3774

I am currently trying to do a for a spreadsheet where each time a type of the same incident occurs, 1 is added to the correlating cell. I am struggling to achieve this. I have tried an IFS and SWITCH but neither work, I keep getting the same error.

=IFS(A5="Animals",B5+1,A5="Appliances",B5+1,A5="Electricity",B5+1,A5="Fire",B5+1,A5="Heating",B5+1,A5="Lifts",B5+1, A5="Property Damage",B5+1,A5="Water",B5+1, A5="Other",B5+1)

=SWITCH(A5,A5="Animals",B5+1,A5="Appliances",B5+1,A5="Electricity",B5+1,A5="Fire",B5+1,A5="Heating",B5+1,A5="Lifts",B5+1,A5="Property Damage",B5+1,A5="Water",B5+1,A5="Other",B5+1)

It keeps saying inconsistent error. If I add equal signs in front it completely breaks. If I take the B5 out they are all "1". If I keep it in they are all "0". I just want to make a tally. Can someone help please?

Example of what I am trying to achieve

Excel is version 2603 build 19822.20182

---

EDIT 1 - SOLVED but feel free to add feedback. Solution ended up as: =IFS(A13="Animals",COUNTIF($A$4:A13,"Animals"),A13="Appliances",COUNTIF($A$4:A13, "Appliances"),A13="Electricity",COUNTIF($A$4:A13,"Electricity"),A13="Fire",COUNTIF($A$4:A13,"Fire"),A13="Heating",COUNTIF($A$4:A13,"Heating"), A13="Lifts",COUNTIF($A$4:A13,"Lifts"),A13="Property Damage",COUNTIF($A$4:A13,"Property Damage"),A13="Water",COUNTIF($A$4:A13,"Water"),A13="Other",COUNTIF($A$4:A13,"Other")) If you can make it tidier be my guest :)

---

I (25f) have been going through a bunch of old stuff and found my old guitar hero games amongst others for xbox 360. I am now on xbix series x. I used to have the drum kit, two guitars, and microphones. Full set up. Loved these games. Unfortunately drumkit didn't survive storage and unsure of guitars atm. However when looking to see if I can convert all my games digitally I found guitar hero wasnt there at all. So I did some digging. Devastated to find out it's completely died 😭. I love going to arcades and seeing it set up. It's literally my alltime fave. I was so excited to try and locate my guitar and play, to find out no backwards compatibility, no digital version, no more replacement instruments. Nothing 😭.

I don't really think there's a solution other than getting second hand equipment and a 360 (but if there is one please let me know 😭) but just wanted to lament the loss of guitar hero (and pray for Activision to resurrect it though unlikely). Would love to hear others memories with guitar hero. RIP 🥲

I (25f) have been going through a bunch of old stuff and found my old guitar hero games amongst others for xbox 360. I am now on xbix series x. I used to have the drum kit, two guitars, and microphones. Full set up. Loved these games. Unfortunately drumkit didn't survive storage and unsure of guitars atm. However when looking to see if I can convert all my games digitally I found guitar hero wasnt there at all. So I did some digging. Devastated to find out it's completely died 😭. I love going to arcades and seeing it set up. It's literally my alltime fave. I was so excited to try and locate my guitar and play, to find out no backwards compatibility, no digital version, no more replacement instruments. Nothing 😭.

I don't really think there's a solution other than getting second hand equipment and a 360 (if there is one please let me know 😭) but just wanted to lament the loss of guitar hero (and pray for Activision to resurrect it though unlikely). Would love to hear others memories or thoughts on guitar hero. RIP 🥲