Counting Specific criteria using "or"

[YourHero]

In a spreadsheet I need to count the number of times the value 7 or 8 appear in a defined range. The formula I use for counting the value 6 specifically is:

=COUNTIFS(E7:E249,"=6")

I’m sure the solution is simple, but so am I.

Thanks

[Villeroy]

=COUNTIF(E7:E249,7)+COUNTIF(E7:E249,8)
A pivot table can display the frequency of all values existing in E7:E249.

[YourHero]

Thanks Villeroy, that’s perfect. Never heard of a pivot table before.

[Villeroy]

• Put a column header in E6, say “Numbers”
• Select E6:E249
• Data>Pilot>Create…
• Create from selection
• Drag “Numbers” to row fields and to data fields.
• Change Sum(Numbers) to Count(Numbers)
• Confirm dialog.