You can't use the entire column in xl2003. Adjust your ranges to be less than
the entire column, but make sure they're the same size.

Greg wrote:

Hi GAV123.

I'm trying to use your formula and am having an issue with it. My formula is:

=SUMPRODUCT(--('9.1 ADMITS'!A:A=Sheet1!A2),--('9.1 ADMITS'!J:J='9.1
ADMITS'!F:F))

But I keep getting a #NUM! error. Any idea what I am doing wrong?

Excel 2003

TIA,

Greg

"Gav123" wrote:

Hi,

Maybe you could try a SUMPRODUCT function, some thing like..

=SUMPRODUCT(--(Range1=criteria1),--(Range2=criteria2))

Hope this helps.

Gav.

"rexmann" wrote:

Hi All

I have a question relating to the CountIF function. I have a need for a
function which uses countIF but the value meets a criteria from 2 columns (or
alternatively has two sets of criteria)

I can get it to work for one column but not two
=COUNTIF('column if data '!D2:D463,"=Yes")

I have tried to add (and 'column of data2 '!E2:E462," =No") and various
variations of the above but no joy

Do you have any suggestions (maybe a countIF is not the way to go)

Any help greatly appreciated

Cheers Rexmann






--

Dave Peterson