| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting with more than one criteria
Hi, I'm new to this and I have probably a easy question. I'm trying to count
the following. If Column B has a P in it and Column H = 100% or more I would like it to count. Sounds pretty easy but for the life of me I can't figure it out. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting with more than one criteria
Try this:
=SUMPRODUCT(--(B2:B10="P"),--(H2:H10=100)) Note: Your ranges must be specified (cannot be entire column). Adjust the ranges as needed. Does that help? Paul -- "Lori" wrote in message ... Hi, I'm new to this and I have probably a easy question. I'm trying to count the following. If Column B has a P in it and Column H = 100% or more I would like it to count. Sounds pretty easy but for the life of me I can't figure it out. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting with more than one criteria
Thanks
"PCLIVE" wrote: Try this: =SUMPRODUCT(--(B2:B10="P"),--(H2:H10=100)) Note: Your ranges must be specified (cannot be entire column). Adjust the ranges as needed. Does that help? Paul -- "Lori" wrote in message ... Hi, I'm new to this and I have probably a easy question. I'm trying to count the following. If Column B has a P in it and Column H = 100% or more I would like it to count. Sounds pretty easy but for the life of me I can't figure it out. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting with more than one criteria
Hi Lori
One way =SUMPRODUCT(($B$1:$B$1000="P")*($H$1:$H$1000=100% )) Change ranges to suit, but note you can't use whole columns as ranges (except for XL2007) -- Regards Roger Govier "Lori" wrote in message ... Hi, I'm new to this and I have probably a easy question. I'm trying to count the following. If Column B has a P in it and Column H = 100% or more I would like it to count. Sounds pretty easy but for the life of me I can't figure it out. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting with more than one criteria
Perfect, Thanks so much.
"Roger Govier" wrote: Hi Lori One way =SUMPRODUCT(($B$1:$B$1000="P")*($H$1:$H$1000=100% )) Change ranges to suit, but note you can't use whole columns as ranges (except for XL2007) -- Regards Roger Govier "Lori" wrote in message ... Hi, I'm new to this and I have probably a easy question. I'm trying to count the following. If Column B has a P in it and Column H = 100% or more I would like it to count. Sounds pretty easy but for the life of me I can't figure it out. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting criteria | Excel Discussion (Misc queries) | |||
| Counting more than one criteria | Excel Discussion (Misc queries) | |||
| Counting, 2 criteria | Excel Discussion (Misc queries) | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Hybrid Mode
