CountIF

  • Thread starter Thread starter LU_CIZ2003
  • Start date Start date
L

LU_CIZ2003

:confused:
do you know which formula I can use to count in a column certain values
based on criteria of another column?
For example:

Column A Column B
1 External org Start-up meeting
2 Internal org Final meeting
3 External org Final Meeting
4 Internal org Meeting to be organised
5 External org Final meeting

How can I count how many final meetings have been organized by an
external organization?

HAve a nice day -ciao
 
You could use sumproduct for this

=SUMPRODUCT((TRIM(A2:A6)="External org")*(TRIM(B2:B6)
="final meeting"))

the trim part is just a security precausion in case there
are some extra spaces involved.. For better usabilty use
a cell where you put in the criteria

=SUMPRODUCT((TRIM(A2:A6)=TRIM(G1))*(TRIM(B2:B6)=TRIM(G2)))

where G1 and G2 hold the criteria.. Personally I would
use data>autofilter any day.. Just filter on the 2
columns and use a formula like

=SUBTOTAL(3,A2:A100)

Regards,

Peo Sjoblom
 
Back
Top