Countif extension

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guy's,
I have a formula i need to create which does the following:
using countif i need to count "bill" then for all the counted bills go to another range and count those cells that matched bill but also match yes.

there are 20 columns of info 1st column is a name then column 2-19 each have yes or no in them, about 100 rows.

i want to match a name in column 1 and count the number then go across and count the yes in the next column but they need to make sure they match.

hope thats kinda clear.
Leo
 
Hi Leo!

Use SUMPRODUCT.

eg

=SUMPRODUCT(--($A$1:$A$15="Fred"),--($B$1:$B$15="yes"))

The -- coerce returns of the implicit IF functions of TRUE to 1 and
FALSE to 0.
 
Back
Top