| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting data/using COUNTIFS
Hi Addatone,
Am Mon, 26 Aug 2013 23:10:28 +0100 schrieb Addatone: I attached a copy of the file. your attached file doesn't work. It gives an error when trying to open. Try: =COUNTIFS(Data!B2:B20,B18,Data!D2:D20,J16) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#2
|
|||
|
|||
|
Thank you Claus Busch!
I tested the formula and it works perfectly. Thank you so much for your help. I truly appreciate it. Addatone. Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying Data grabbed using concatenates and CountIfs | Charts and Charting in Excel | |||
| Need to use Countifs to return unique data | Excel Worksheet Functions | |||
| Selecting data in a specific date range using COUNTIFS function | Excel Worksheet Functions | |||
| Countifs of prior years monthly data based on MTD today | Excel Worksheet Functions | |||
| Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
Hybrid Mode
