Which (logical) function?

J

JustJill

Table was codes...if the ID begins with a w and the number in the second
column is a 1 add the ones (which are male ;)

A B
1 ID Gender
2 W01 2
3 W02 1
4 G01 1
5 W08 1

I have: =COUNTIF(A$2:$A$5,"=w??")*AND(COUNTIF(B$2:$B$5,"1"))...which isn't
correct because it returns 3 (all the w's) I suppose.

What do I do???

TIA!
 
F

Fred Smith

For more than one criteria, use Sumproduct, as in:
=sumproduct((left(a2:a5)="w")*(b2:b5=1))

Regards,
Fred
 

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

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
How to Import Formatted text as new Slides in PowerPoint 0
Need some PWA help 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Formating bolded text exclusively. 0
Finding the weighted average of text that have been given values 1
How can the font and size of (all) citation numbers be altered? 1

Top