countif to total summary two different values into one
I have a sheet with different values I would like to sum a group of them and not in detail.
Example I have values like CAR, BUS, TABLE, CHAIR
I am trying to use a countif formula to sum up a total off all vehicles, like CAR and BUS.
So I tried countifs(Range:range, CAR, Range:Range, BUS)
however that doesnt seam to work. Any ideas?
Help Article Resources
Check out the Formula Handbook template!