Posted to microsoft.public.excel.worksheet.functions

Steve

external usenet poster

Posts: 1,814

COUNTIF? DCOUNT?

I have a very large worksheet... One column contains the NUMBER of demands
for an item in a given year; another column contains the DOLLAR VALUE of
those demands. I need to COUNT the number of rows where the NUMBER of
demands is greater than 100 and the DOLLAR VALUE of the annual demand is
greater than $6000. Been struggling with COUNTIF and DCOUNT. Any help?
--
Grateful

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
DCOUNT Help!	fearthespear	Excel Discussion (Misc queries)	1	November 7th 08 06:02 AM
DCount help	Engels	Excel Worksheet Functions	4	January 8th 07 04:18 PM
DCOUNT with different files	stratis	Excel Worksheet Functions	0	November 11th 06 04:14 PM
dcount with vba	J Slavin	Excel Worksheet Functions	2	March 26th 06 05:01 PM
dcount vba	J Slavin	Excel Worksheet Functions	0	March 26th 06 03:39 AM

All times are GMT +1. The time now is 08:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us