Countif extension

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
 
N

Norman Harker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif? or Vlookup? Lost?? 3
countif only when an exact match occurs 5
countif 1
Need Help FAST with COUNTIF Formula 0
CountIF() & SumIF() with multiple criteria 5
COUNTIF with two conditions 2
CountIf question 2
COUNTIF for 2 columns 6

Top