Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
tg tg is offline
external usenet poster
 
Posts: 58
Default CountIf Dynamic

How can I use the CountIf dynamically?

COUNTIF($E$6:$E$2725,"= J47")-COUNTIF($E$6:$E$2725,"= K47")

Where J47 and K47 are numeric cell references. If this isn't possible, how
can I count a column of values in a user defined range.

Thank you very much.
 
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
Countif with Dynamic date ranges. Leonhardtk Excel Worksheet Functions 2 July 12th 07 02:46 PM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill ers Charts and Charting in Excel 0 March 1st 06 01:05 AM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Offset, Dynamic range, Countif Bryce Excel Discussion (Misc queries) 3 October 26th 05 12:58 PM
Countif with dynamic criteria FinChase Excel Worksheet Functions 5 January 6th 05 07:19 PM


All times are GMT +1. The time now is 10:06 AM.

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"