SUMIFS and COUNTIFS Formula Builder

I need help creating a SUMIFS or COUNTIFS formula:

**Function Needed:**
- [ ] SUMIFS (sum values meeting criteria)
- [ ] COUNTIFS (count cells meeting criteria)
- [ ] AVERAGEIFS (average values meeting criteria)
- [ ] MAXIFS / MINIFS

**Data Structure:**
- Sum/Count range: [e.g., D2:D1000 - Sales Amount]
- Data table location: [e.g., A1:F1000]

**Criteria (list all):**
| Criteria Range | Condition | Value |
|----------------|-----------|-------|
| [e.g., B2:B1000 - Region] | [equals/greater than/contains] | [e.g., "North"] |
| [e.g., C2:C1000 - Date] | [e.g., >= ] | [e.g., 1/1/2024] |
| [Add more rows as needed] | | |

**Special Requirements:**
- Criteria from cell references: [Yes/No]
- Wildcards needed: [Yes/No - e.g., *text*]
- Date range criteria: [Yes/No]
- OR logic needed: [Yes/No - SUMIFS is AND by default]

Please provide:
1. The complete formula
2. Breakdown of each component
3. Alternative approaches for complex logic
4. Common errors and how to fix them
5. Performance tips for large datasets