The formula that I gave is just as valid as with a * operator (see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for an explanation), but
what value is there in testing A1:A100 for A&E twice?
Bob
"Pierre Leclerc" wrote in message
...
Hi
the formula is:
=sumproduct((B1:B100="Admit to
Hospital")*(A1:A100="A&E")*(A1:A100="A&E"))
See other example of SUMPRODUCT at hte address below
http://www.excel-vba.com
On Sun, 21 Nov 2004 05:09:35 +0000 (UTC), Iain Halder
wrote:
Bob,
Thank you for replying!
I tried this as you suggested but the cells came up blank.
The comparison is not between numbers but between texts
i.e. =sumproduct(--(A1:A100="A&E"),--(B1:B100="Admit to Hospital"))
The idea is to do a count of people who attend A&E and who are then
admitted to the hospital. There are many other options in these two
columns but I need to be able to quickly count these particular two.
Am I doing this wrong in some way?
Iain Halder
On Sat, 20 Nov 2004 20:24:53 -0000, "Bob Phillips"
wrote:
=SUMPRODUCT(--(A1:A100="value1"),--(B1:B100="value2"))
Rescued Cats & Kittens Needing Homes
'o'< www.celiahammond.org 'o'<
'o'< www.cat77.org.uk 'o'<
Pierre Leclerc
http://www.excel-vba.com