Formula to count items in a range if specific criteria is met Here is a snapshot

Question

Formula to count items in a range if specific criteria is met

Here is a snapshot of my spreadsheet

In Cell B2 _ want to enter a formula that will look at column J4:J6 and if the value is 0-7 count those cells and return a result -- for this example 1

In Cell D2 want to enter a formula that will look at column J4:J6 and if the value is 8-14 count those cells and return a result -- for this example 2

In Cell F2 want to enter a formula that will look at column J4:J6 and if the value is 8-14 count those cells and return a result -- for this example 0

Thank for help !!

0-7 Days 8-14 Days 15-21 Days Total Date Entered Dealership Contact Days 2/23/15 Stamas Auto & Truck Center Lee Stamas 2 2/5/15 Prestige Auto Mart Michelle Arruda 14 2/7/15 Pride Hyundai of Seekonk Bill Oldmixon 12

Explanation / Answer

Hi..

In B2 try

=COUNTIFS(J4:J6,">=0",J4:J6,"<=7")

0 and 7 both inclusive... if you want >0 and < 7 then use

=COUNTIFS(J4:J6,">0",J4:J6,"<7")

Use similar formulae in other cells.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.