| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with additional qualifiers?
I like the COUNTIF function but want to include the ability to expand
the "match" criteria to include data in other columns. Possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF with additional qualifiers?
One way is to use SUMPRODUCT
An excellent resource on SD is Bob Phillips' page at: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Larry" wrote in message oups.com... I like the COUNTIF function but want to include the ability to expand the "match" criteria to include data in other columns. Possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF with additional qualifiers?
On Apr 8, 12:30 am, "Max" wrote:
One way is to use SUMPRODUCT An excellent resource on SD is Bob Phillips' page at:http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Perfect! Exactly what I was after. Wish I'd known this 4 years ago! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF with additional qualifiers?
It's never too late, Larry <g !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Larry" wrote Perfect! Exactly what I was after. Wish I'd known this 4 years ago! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove text qualifiers from imported data? | Excel Discussion (Misc queries) | |||
| How do I use 3 separate column qualifiers to sum? IF statements? | Excel Worksheet Functions | |||
| Table lookup using multiple qualifiers | Excel Discussion (Misc queries) | |||
| Saving as a csv file with text qualifiers | Excel Discussion (Misc queries) | |||
| SUMIF/COUNTIF with an additional criteria | Excel Worksheet Functions | |||
![Larry[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
