LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying Data grabbed using concatenates and CountIfs woodland81 Charts and Charting in Excel 2 June 7th 12 10:24 PM
Need to use Countifs to return unique data ascottbag-hcm Excel Worksheet Functions 1 October 28th 09 07:22 PM
Selecting data in a specific date range using COUNTIFS function Joe R @ AA[_2_] Excel Worksheet Functions 1 May 8th 09 02:29 PM
Countifs of prior years monthly data based on MTD today Joe R @ AA Excel Worksheet Functions 3 April 14th 09 04:09 PM
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve Excel Worksheet Functions 2 January 4th 09 05:36 PM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"