Countifs w/ two date ranges and two different sheet

Ryan Holguin

Hello All,

I am trying to count the number of projects within the same date range, but there are two different sheets I need to pull this from. I keep getting an INCORRECT ARGUEMENT SET. Here's the idea of what I have:

=COUNTIFS({Sheet1}, Criterion1 , {Sheet1 Date Range}, AND(@cell >= DATE(2023, 7, 1), @cell <= DATE(2023, 12, 31)), {Sheet2}, Criterion1, {Sheet2 Date Range}, AND(@cell >= DATE(2023, 7, 1), @cell <= DATE(2023, 12, 31)))

Here's the actual snippet:

What am I missing? Thanks!

Darren Mullen

@Ryan Holguin As as I know you can't reference ranges from 2 different sheets in a single function. However, what you can do is use 2 COUNTIFS and add the result together.

Like this. (I didn't check the parenthesis for any extras or missing):

=COUNTIFS({Sheet1}, Criterion1 , {Sheet1 Date Range}, AND(@cell >= DATE(2023, 7, 1), @cell <= DATE(2023, 12, 31)) + COUNTIFS( {Sheet2}, Criterion1, {Sheet2 Date Range}, AND(@cell >= DATE(2023, 7, 1), @cell <= DATE(2023, 12, 31)))