| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIFS function not supported in Excel 2003
Excel 2003 not support COUNTIFS function so How do I convert the
following formula in order to run on Excel 2007 ? COUNTIFS('Raw Data'!$E:$E,"<=4",'Raw Data'!$I:$I,"1") Regards, Tee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNTIFS function not supported in Excel 2003
Hi
Try COUNTIF. There is no COUNTIFS function. regards Paul On Jun 9, 9:51*am, wrote: Excel 2003 not support COUNTIFS function so How do I convert the following formula in order to run on Excel 2007 ? COUNTIFS('Raw Data'!$E:$E,"<=4",'Raw Data'!$I:$I,"1") Regards, Tee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNTIFS function not supported in Excel 2003
Maybe
=SUMPRODUCT(('Raw Data'!E1:E1000<=4)*('Raw Data'!L1:L1000=1)) Mike " wrote: Excel 2003 not support COUNTIFS function so How do I convert the following formula in order to run on Excel 2007 ? COUNTIFS('Raw Data'!$E:$E,"<=4",'Raw Data'!$I:$I,"1") Regards, Tee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Viewer 2003 supported file types | Excel Discussion (Misc queries) | |||
| Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
| Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
| translating countifs function to Excel 2003 | Excel Worksheet Functions | |||
| date type format which is supported by excel 2003 | Charts and Charting in Excel | |||
Linear Mode
