From the manner that you reflected the "criteria", it looks just like a
typical pivot table output, with the col headers for Criteria1/2 placed
within the ROW area (Criteria2 below Criteria1), and the col header for Value
placed in the DATA area, set to SUM.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"ControllerInVa" wrote:
I am trying to retrieve values from a database with multiple criteria that
change from row to row. Is there any way possible to build into the formula
"dynamic" criteria without having to create massive criteria tables? Back in
the Lotus days you could build the criteria into the formula.

DB would look like...

Criteria1 Criteria2 Value
A 1 $10
A 2 $15
B 1 $20
B 2 $25