MIN & MAX Formula with Multiple Variables

[marko0223]

I am trying to get the MIN loan amount and the MAX loan amount in the data I have. I need to find them within a date range and I need the Freddie and Fannie loans as one group and FHA loans in their own group within the same date range. Some of the FHA loans are on 2 different sheets. Is there a way to do this? If this doesn't make sense I can try and clarify. Here is an example of the data:


Sheet 1

1/5/19 Fannie $1,000,000.00
1/6/19 Freddie $8,000,000.00
1/7/19 Fannie $4,000,000.00
1/7/19 FHA $10,000,000.00

Sheet 2

1/9/19 FHA $11,000,000.00
1/11/19 FHA $3,000,000.00


Sheet 3

This is where my formula is going.

 

[marko0223]

Awesome! That worked great. I really appreciate it.