Countif funtion

  • Thread starter Thread starter Guest
  • Start date Start date
To simplify the calculation, you could add a formula in column N, with
the heading "Closed By":

=IF(L2<>"Closed","",IF(M2="",K2,M2))

This would calculate the name of the person who closed the file.
Then, count the names in that column, using a COUNTIF formula. For
example:
=COUNTIF(N2:N1669,P2)
Where P2 contains a name.
 
Debra you rock!!!! Thank you so much!!! That worked and everything is
falling place now. Thanks for everyone's help to figure this out I learned a
lot the last few days on using formulas!
 
hi

i am trying to count cells in one column that match a criteria another column

Table A Table B Table C
Location Product Company

Ports Area A XYX co
Corniche area B ABC co
City area B DTS co
Village area C GHK co
Corniche area A PQR co
City area C ABC co

Here i know from the above table that there are two companies in "corniche
area" bu doing count but how do i get how many companies in 'corniche area '
that buy product A ?

regards

rajesh
 
Try this...

Locations in column A
Products in column B

E1 = Corniche area
F1 = A

=SUMPRODUCT(--(A1:A10=E1),--(B1:B10=F1))
 
Back
Top