sumif, countif, sumproduct?????

  • Thread starter Thread starter m fleming
  • Start date Start date
M

m fleming

Hello,

I have two columns: Col C, yes, yes, no, yes, yes and Col D, yes, no, yes,
yes, Yes. I want to count on col D if it says yes and the coresonding cell
in Col C says yes. Thus I would like a formula to return a count of 3 for
this example.
 
{=SUM(IF((C1:C100="yes"),IF(D1:D100="yes",1,0)))}

You would obviously substitute the C1:C100 and D1:D100 with the rang
you need.

This is not case sensativ
 
You could leave out the IF statements (either way works, but with more
complex formulae you could have problems w/the 7 nested function limit using
IF statements).

{=SUM((F4:F7="yes")*(G4:G7="yes"))}

or
=SUMPRODUCT(--(F4:F7="yes"), --(G4:G7="yes"))
 
You must log in or register to reply here.

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

Counting number of rows based on mutiple criteria 2
Lookup when value is between 2 columns 4
Which function will shorten IF-THEN-ELSE ? 5
Sum with 2 if's 1
SUMPRODUCT and OR operator 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
countif criteria 6
SUMPRODUCT Difficulty 11

Back
Top