Bob-

Saw your message on a reply to a user looking for a SUMIF type
operation. I've got a similar situation where I have a rather large
data base (~12000 rows) x 48 columns. I've used the SUMIF extensively
to locate and count data from a SINGLE column and it works fine. But
I've got to further refine the searches now to include each STATE that
data comes from. One of the columns in the data array has the state
data listed. What I need to accomplish is to find all the instances of
a lookup value (column A from the report sheet) by using SUMIF from the
data array. Works good. But I need to FILTER the SUMIF command to now
include a type of (IF column R from the data array = "Alabama") then
count that rows figures in the SUMIF command processing.

I'm not having any luck. Any advice??

Brian