Condition row counting.


Posted by Hasib on November 14, 2001 11:42 AM

This is probably pretty simple for most of the readers of this board. I have one column with customer name and another with week #. I need to count the number of rows where the customer name is say "Nestle" AND the week # is say '40.' Actually a range of cells in a column would work better for me. Any help would be greatly appreciated. Thanks in advance! --Hasib..

Posted by Aladin Akyurek on November 14, 2001 11:54 AM

=SUMPRODUCT((A1:A100="Nestle")*(B1:B100=4))

Aladin



Posted by Hasib on November 14, 2001 2:10 PM

Re: Conditional row counting.

Thanks!!!