[2003] "Countif" from two columns

  • Thread starter Thread starter Bob Flaminio
  • Start date Start date
B

Bob Flaminio

I have a spreadsheet of this form:

A No
B Yes
A Yes
C No
C Yes
B No
A Yes
B No

I would like a function that would do a count based on values in both
columns. For example, a count of all of the "A" "Yes" would equal 2.
Anyone have any ideas how to do this?
 
Bob said:
I have a spreadsheet of this form:

A No
B Yes
A Yes
C No
C Yes
B No
A Yes
B No

I would like a function that would do a count based on values in both
columns. For example, a count of all of the "A" "Yes" would equal 2.
Anyone have any ideas how to do this?
Click to expand...

Thanks to Dave R. and Frank Kabel -- those formulae worked perfectly!
 
John said:
Why not use a PivotTable; it wil give you all the
information you require.
Click to expand...

Good suggestion, but in this specific instance I needed a function. The
previous answers worked famously.
 
Back
Top