| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AND function using COUNTIF
I would like to count entries in column "B" that equal a criteria and also
meet a criteria in column "A". For EX: If entry in column "A" equals "Walt" and entry in column "B" equals "x" then count Note: I think I had a solution a few years ago that used the -- function. Please help me solve this again. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AND function using COUNTIF
=SUMPRODUCT(--(A2:A200="Walt"),--(B2:B200="x"))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Walter L. skinner" wrote in message ... I would like to count entries in column "B" that equal a criteria and also meet a criteria in column "A". For EX: If entry in column "A" equals "Walt" and entry in column "B" equals "x" then count Note: I think I had a solution a few years ago that used the -- function. Please help me solve this again. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AND function using COUNTIF
Hi Walter,
You could try something like this.. =SUMPRODUCT(--(A1:A1000="Walt"),--(B1:B1000="X")) Hope this helps, Gav. "Walter L. skinner" wrote: I would like to count entries in column "B" that equal a criteria and also meet a criteria in column "A". For EX: If entry in column "A" equals "Walt" and entry in column "B" equals "x" then count Note: I think I had a solution a few years ago that used the -- function. Please help me solve this again. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AND function using COUNTIF
=sumproduct((a2:a22="Walt")*(b2:b22="x"))
-- Don Guillett Microsoft MVP Excel SalesAid Software "Walter L. skinner" wrote in message ... I would like to count entries in column "B" that equal a criteria and also meet a criteria in column "A". For EX: If entry in column "A" equals "Walt" and entry in column "B" equals "x" then count Note: I think I had a solution a few years ago that used the -- function. Please help me solve this again. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AND function using COUNTIF
=SUMPRODUCT((A1:A100="Walt")*(B1:B100="x")) or
=SUMPRODUCT(--(A1:A100="Walt"),--(B1:B100="x")) -- David Biddulph "Walter L. skinner" wrote in message ... I would like to count entries in column "B" that equal a criteria and also meet a criteria in column "A". For EX: If entry in column "A" equals "Walt" and entry in column "B" equals "x" then count Note: I think I had a solution a few years ago that used the -- function. Please help me solve this again. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
| Function Help - COUNTIF | New Users to Excel | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| countif function | Excel Worksheet Functions | |||
Linear Mode
