# Thread: COUNTIFS - Summary of all data Thanks: 0 Likes: 0

1. ## COUNTIFS - Summary of all data

When trying to count a particular group (Group 1 or Group 2) I am getting the correct data (1)
How to get the overall data (2) using COUNTIFS

 Group Status Group 1 Not Started Group 2 Not Started

=COUNTIFS(\$B:\$B,"Not Started",\$A:\$A,"Group 1")

2. ## Re: COUNTIFS - Summary of all data

Hi,

ABCD
1GroupStatus3
2Group 1Not Started
3Group 3Not Started
4Group 2Not Started
5Group 1Not Started

Sheet632

Worksheet Formulas
CellFormula
D1=SUM(COUNTIFS(\$B:\$B,"Not Started",\$A:\$A,{"Group 1","Group 2"}))

3. ## Re: COUNTIFS - Summary of all data

What if i need the count for a particular group if selected. If not, then the count for all the groups ?

Originally Posted by jtakw
Hi,

A B C D
1 Group Status 3
2 Group 1 Not Started
3 Group 3 Not Started
4 Group 2 Not Started
5 Group 1 Not Started
Sheet632

Worksheet Formulas
Cell Formula
D1 =SUM(COUNTIFS(\$B:\$B,"Not Started",\$A:\$A,{"Group 1","Group 2"}))