Nesting Problem

[vgreen]

thanks to someone on this board earlier on I can create the first par
of this calculation but am unable to join a second criteria within it.
In simple language:

Count number of occurrences where

First Part
Sheet 1, Col A:A is >= Sheet 2 Cell 1, and also <= Sheet2 Cell 2,

Second Part (dependent on result of first part)
if Sheet 1 Col P is GT= 0, and also LT= 999,999

Where Col A and Cells 1 and 2 are dates and Col P is a price range.
S(o that the function finds the number of properties inspected withi
any chosen date range, that also then fall between a given price pric
range.)

I used SUMProduct for the first part which works fine and I thought
could do same for the second part and use * to join together bu
doesn't work.

Any help greatfully received.

V

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A1000>=Sheet2!A1),--(A2:A1000<=Sheet2!A2),--(P21000>=0),
--(P21000<=999999))

SUMPRODUCT only works on part of a column, and the ranges must be the same
size

--

HTH

RP
(remove nothere from the email address if mailing direct)