Help!

Using count in AND statement
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map RSS
Next:  Excel error Message  
Author Message
anamarie30
External


Since: Mar 12, 2007
Posts: 3
PostPosted: Mon Mar 12, 2007 6:58 am    Post subject: Using count in AND statement
Archived from groups: microsoft>public>excel>datamap (more info?)
Hi,

I tried to make a formula that count if two statements are true. For example,
=COUNTIF(M!E2:E37,"P") This formula give me the correct number that is 7.
=COUNTIF(M!L2:L37,"Y") This formula give me the correct number that is
25.

Then, I tried to combined this 2 formulas for using a conditional statement
AND, because I want that the formula count when this 2 statements are true.
=AND((COUNTIF(M!E2:E37, "P")), (COUNTIF(M!L2:L37, "Y"))) Result: True

Then, I tried to make the count if this condition are True, but the count
give a wrong number. The formula that I tried is
=COUNT(AND((COUNTIF(M!E2:E37, "P")), (COUNTIF(M!L2:L37, "Y"))))

Thanks
Back to top
Gary''s Student
External


Since: Oct 01, 2005
Posts: 3200
PostPosted: Sat Mar 17, 2007 2:44 am    Post subject: RE: Using count in AND statement [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
=SUMPRODUCT(--(E2:E37="p"),--(L2:L37="y"))
--
Gary''s Student
gsnu200710
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum