Chip Pearson's site:
http://www.cpearson.com/excel/array.htm
shows how to use multiple criteria to get counts and sums.
--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"klmiura" wrote:

I have the following worksheet lists:
Insurance Company
Amount Paid
Date Paid

On the second worksheet I have an A/R schedule and I need to pull the total
amount paid from above based upon the insurance company name between two
dates ie...60-90 day category 10/01/2006-08/01/2006. I have been trying to
gather this formula all day and I cannot seem to get it.