# Countifs help

#### eschrichj

##### New Member
I was looking up countifs to see if that formula would help me, and it seems to be close to what I need.
I found this example online, but what I'm looking for is a way to search the whole document, and find how many units each individual person sold. Could I have one formula per person that found every unit sold that specific person sold?

5 = =COUNTIFS(\$A\$2:\$A\$9, ">="&\$F\$1,\$A\$2:\$A\$9,"<="&\$F\$2)
1 = =COUNTIFS(\$A\$2:\$A\$9,">="&\$F\$1,\$A\$2:\$A\$9,"<="&\$F\$2,B\$2:B\$9,"="&\$F\$4)

 Date Personnel Sold State Date: 11/7/2011 11/11/2011 Bill 87 End Date: 11/11/2011 11/11/2011 Susan 73 5 11/9/2011 Alexis 26 Personnel: Alexis 11/12/2011 Alexis 75 1 11/8/2011 Kate 19 11/7/2011 Bill 33 11/13/2011 Susan 25 11/14/2011 Kate 82

<tbody>
</tbody>

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### etaf

##### Well-known Member
do you need to SUMIFS() to sum up the SOLD numbers

otherwise you are just counting how many times the name appears during those dates - is that what you are after ?

#### SQUIDD

##### Well-known Member
i would think sumif or sumifs may be the way to go,

do you need an example?

Dave

#### tpbond1

##### New Member
=SUMIFS(sold_column,personel_column,personel_name,date,">="&start_date,date,"<="&end_date)

#### SQUIDD

##### Well-known Member
example anyway

=SUMIFS(C:C,B:B,F4,A:A,">="&F1,A:A,"<="&F2)

dave

#### Anand Sharma

##### Board Regular
If you want total sale for a given period by a particular Person, then you should use sumifs as below

=SUMIFS(C2:C9,\$A\$2:\$A\$9,">="&\$F\$1,\$A\$2:\$A\$9,"<="&\$F\$2,B\$2:B\$9,"="&\$F\$4)

#### eschrichj

##### New Member
Yes sumifs was the way to go. I had never used that formula before, thanks for the quick answer everyone!

youre welcome

Replies
7
Views
145
Replies
7
Views
227
Replies
6
Views
328
Replies
3
Views
189
Replies
16
Views
492

1,191,349
Messages
5,986,147
Members
440,005
Latest member
tombamber

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back