Hi,
You can also try the following array formula (Ctrl+Shift=Enter)
SUM(IF((B3:B9="a")*(C3:C910),1))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Steve" wrote in message
...
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