CountIF formula between two sheets

SiddV47

Hello,

Can someone please point out what's wrong in this formula: =(COUNTIFS({Applied Grants}, "Applied", {submission date}), AND(@cell >= DATE (2025, 1, 1), @cell <= DATE(2025, 12, 31))

I would like to count the total number of grants with the status "Applied" between the Submission date of Jan 1 - Dec 31 2025.

Please refer to image in sheet "A" - The formula gives the following error.

Here are the relevant columns for sheet "B". This is where the COUNTIF formula for sheet "A" looks into.

Melissa Yamada

Hello @SiddV47

Looked like you got extra parenthesis there and an extra space after the first DATE function.

Try this:

=COUNTIFS({Status Column}, "Applied", {Submission Date Column}, AND(@cell >= DATE (2025, 1, 1), @cell <= DATE(2025, 12, 31)))

Make sure to select the correct cross-sheet references.