Countifs help

[eschrichj]

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?
Thanks in advance.

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>

 

[etaf]

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]

i would think sumif or sumifs may be the way to go,

do you need an example?

Dave

 

[tpbond1]

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

 

[SQUIDD]

example anyway

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

dave

 

[Anand Sharma]

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]

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

 

[SQUIDD]

youre welcome