| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumif similar to Countif??
Hello. I'm looking for a variation of the formula Countif tht will operate in a similar fashion to the Sumif.
In column A I have various categories. In column B I have either blank cells or numbers. I need to scan column A to indentify a category (Apple for example), and then COUNT the non-blank cells for Apple in column B. Any ideas? Thanks so much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max/min functions similar to SUMIF | Excel Discussion (Misc queries) | |||
| Can I do a MAXIF similar to SUMIF and/or COUNTIF? Please Advise | Excel Discussion (Misc queries) | |||
| similar to sumif() but for averages | Excel Discussion (Misc queries) | |||
| A formula maxif, similar with sumif or countif | Excel Worksheet Functions | |||
| sumif with similar cells | Excel Worksheet Functions | |||
![Steve[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
