| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Several Countif criteria
Hi there,
I would like to do count values greater than 20 and less than 36 in Column C, if looking for "B" in column A and "NO" in column B. Please extract of the spreadsheet below. Column A Column B Column C A YES 15 B NO 20 B NO 35 B YES 36 B NO 37 B NO 25 B YES 30 B NO 10 K YES 10 K NO 10 I have tried with sum and sumproduct but am not able to get it right. Any help much appreciated. -- Regards, Martin |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Several Countif criteria
Try this:
Using your data in Cells A1:C10 D1: =SUMPRODUCT((A1:A10="B")*(B1:B10="NO")*(C1:C1020) *(C1:C10<36)) Does that help? *********** Regards, Ron XL2002, WinXP "Martin" wrote: Hi there, I would like to do count values greater than 20 and less than 36 in Column C, if looking for "B" in column A and "NO" in column B. Please extract of the spreadsheet below. Column A Column B Column C A YES 15 B NO 20 B NO 35 B YES 36 B NO 37 B NO 25 B YES 30 B NO 10 K YES 10 K NO 10 I have tried with sum and sumproduct but am not able to get it right. Any help much appreciated. -- Regards, Martin |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Several Countif criteria
Many many thanks Ron,
It works like a dream. -- Regards, Martin "Ron Coderre" wrote: Try this: Using your data in Cells A1:C10 D1: =SUMPRODUCT((A1:A10="B")*(B1:B10="NO")*(C1:C1020) *(C1:C10<36)) Does that help? *********** Regards, Ron XL2002, WinXP "Martin" wrote: Hi there, I would like to do count values greater than 20 and less than 36 in Column C, if looking for "B" in column A and "NO" in column B. Please extract of the spreadsheet below. Column A Column B Column C A YES 15 B NO 20 B NO 35 B YES 36 B NO 37 B NO 25 B YES 30 B NO 10 K YES 10 K NO 10 I have tried with sum and sumproduct but am not able to get it right. Any help much appreciated. -- Regards, Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF with two criteria | Excel Worksheet Functions | |||
| countif criteria only one word of few doesn't work | Excel Worksheet Functions | |||
| Countif w/ Multiple Criteria | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Linear Mode
