In EXCEL 2003, I have used this function
=DMAX(Incidents!O:O,"POB",Incidents!O1:O2) to find the highest figure in
column O of my Incidents spreedsheet but I can't for the life of me DMAX only
part of that same column on that same spreedsheet to get a year by year
highest total. I have tried changing the Database to be the portion I want to
DMAX without success. I have also fiddled with several different variations
of the criteria without success. O1 is column name "POB", O2 is blank, and O3
has "4" in it. I want to DMAX O546 thru to about O1000.
Help me and I'll be forever in your debt.
Thanks
Stu

If you have dates in another column you could use sumproduct.
You could also add to the criteria range to test for the dates. You would
do that by changing O1:O2 to O1:P2. Then put the heading of the year column
in P1 and put the year you want to analyze in p2.
BTW, =MAX(O:O) would return the same thing as your DMAX formula.


"Stu Leslie" wrote:

In EXCEL 2003, I have used this function
=DMAX(Incidents!O:O,"POB",Incidents!O1:O2) to find the highest figure in
column O of my Incidents spreedsheet but I can't for the life of me DMAX only
part of that same column on that same spreedsheet to get a year by year
highest total. I have tried changing the Database to be the portion I want to
DMAX without success. I have also fiddled with several different variations
of the criteria without success. O1 is column name "POB", O2 is blank, and O3
has "4" in it. I want to DMAX O546 thru to about O1000.
Help me and I'll be forever in your debt.
Thanks
Stu

JBoulton,
Thanks. As I haven't attempted sumproduct yet, I wasn't brave enough to give
it a try. However your MAX formula go me thinking ... and I've found that I
can just MAX the portion I desire. The formula box that comes up talks about
figures 1 to 30 so I assumed I could only select 30 cells ... NOT SO! I MAX'd
450 cells and gave me the result I desired.
Thanks again
Stu



"JBoulton" wrote:

If you have dates in another column you could use sumproduct.
You could also add to the criteria range to test for the dates. You would
do that by changing O1:O2 to O1:P2. Then put the heading of the year column
in P1 and put the year you want to analyze in p2.
BTW, =MAX(O:O) would return the same thing as your DMAX formula.


"Stu Leslie" wrote:

In EXCEL 2003, I have used this function
=DMAX(Incidents!O:O,"POB",Incidents!O1:O2) to find the highest figure in
column O of my Incidents spreedsheet but I can't for the life of me DMAX only
part of that same column on that same spreedsheet to get a year by year
highest total. I have tried changing the Database to be the portion I want to
DMAX without success. I have also fiddled with several different variations
of the criteria without success. O1 is column name "POB", O2 is blank, and O3
has "4" in it. I want to DMAX O546 thru to about O1000.
Help me and I'll be forever in your debt.
Thanks
Stu