Counting entries in 2+ columns
Toppers and Bob,
That's great. But how about selecting the entire column:
=SUMPRODUCT((ALL!B:B="Bahrain")*(ALL!D:D="Power"))
i.e. B:B rather than B2:B457
?
"Bob Phillips" wrote:
You should be able to quite happily
=SUMPRODUCT(--('Other sheet name'!A1:A10="UAE"),--('Other sheet
name'!B1:B10="Construction"))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"petess" wrote in message
...
Toppers,
Further to my earlier post, however, I find that I cannot use the formula
you suggest to work with data from ANOTHER worksheet within the same Excel
file... I can still get the answers I need in the same worksheet, but
this
would be more elegant.
Petess
|