| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use countif like sumif ie (range,criteria,count_range)
Hi,
The syntax of the COUNTIF() is different from that of SUMIF(). The COUNTIF() function takes 2 inouts - range and criteria only. In the SUMIF(), you can (optional) supply the sum range as well. Please read up on COUNTIF() in the Help menu. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "tmarie" wrote in message ... I need to count cells with values by reference to a range in the same way that sumif sums them ie countif(a1:a10,a40,c1:c10) This doesn't work but I'm hoping there's another way? cheers thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIf and CountIf Multiple Criteria | Excel Worksheet Functions | |||
| Countif or sumif with 2 criteria | Excel Discussion (Misc queries) | |||
| Countif & Sumif with Multiple criteria | Excel Worksheet Functions | |||
| multiple criteria with countif or sumif | Excel Worksheet Functions | |||
| SUMIF/COUNTIF with an additional criteria | Excel Worksheet Functions | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
