# Help stacking COUNTIFS?

Options
✭✭

I have two fully operational COUNTIFS functions that calculate independently without issue. One counts how many absences occurred in a specific time range by referencing a date column on an attendance tracking sheet. The other counts how many absences occurred in a specific location by referencing a location column on the same tracking sheet.

I am trying to calculate how many absences occurred in a specific location for a specific date range, in this case how many absences occurred in the month of April 2024 at the ALX location, but I cannot figure out how to stack these two formulas.

First formula: =COUNTIFS({Attendance Tracking - All Records Range 2}, <=DATE(2024, 4, 30), {Attendance Tracking - All Records Range 2}, >=DATE(2024, 4, 1))

Second formula: =COUNTIFS({Attendance Tracking - All Records Range 3}, "ALX")

TIA!

Tags:

## Best Answer

• ✭✭✭✭✭✭
Answer ✓
Options

Take formula 1 and add a comma and paste in the range and criteria from formula 2

=COUNTIFS({Attendance Tracking - All Records Range 2}, <=DATE(2024, 4, 30), {Attendance Tracking - All Records Range 2}, >=DATE(2024, 4, 1),{Attendance Tracking - All Records Range 3}, "ALX")

## Answers

• ✭✭✭✭✭✭
Answer ✓
Options

Take formula 1 and add a comma and paste in the range and criteria from formula 2

=COUNTIFS({Attendance Tracking - All Records Range 2}, <=DATE(2024, 4, 30), {Attendance Tracking - All Records Range 2}, >=DATE(2024, 4, 1),{Attendance Tracking - All Records Range 3}, "ALX")

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!