Forum Discussion

Copper Contributor

Jun 24, 2020

Solved

Need help with a COUNTIFS formula

I'm working on a spreadsheet for state reporting (I work for a school district) and I need to get the unduplicated number of students who received a suspension or in-house suspension. I've marked...

Formulas and Functions

Twifoo
Jun 25, 2020
Try this formula:
=SUM(COUNTIFS(A2:A57,”X”,
P2:P57,{“SUS”,”IH”}))

Twifoo

Silver Contributor

Jun 25, 2020

Try this formula:
=SUM(COUNTIFS(A2:A57,”X”,
P2:P57,{“SUS”,”IH”}))

dpeck
Copper Contributor
Jun 25, 2020
Twifoo Thank you, thank you, thank you!!! That worked beautifully!!
- Twifoo
  Silver Contributor
  Jun 25, 2020
  You’re welcome!
  - dpeck
    Copper Contributor
    Jun 25, 2020
    Now, how about if I need to count Incident codes from 3 different columns?
    
    I tried to tweak the previous one, but it didn't work. What I originally had was:
    =COUNTIFS(T2:T10,"300",W2:W10,"300",Z2:Z10,"300") - that brought up 0.
    
    I tried =SUM(COUNTIFS({T2:T10,W2:W10,Z2:Z10},"300")) but that caused an error.
    
    I tried =SUM(COUNTIFS(T2:T10,W2:W10,Z2:Z10,{"300"})) - that brought up 0
    
    So basically, I need a total of all the 300 codes from column T, W & Z. Is that possible?