Can somebody help trying to read only data from this Month

Eric Goldsmith

Hi

My plan is to bring data from the current month, from a different sheet using cross sheets formulas. My code below is not working any idea why? It says #UNPARSEABLE

Any help is much appreciated

=SUMIF({Actual Completion Date}@row)=MONTH(TODAY()),({Completed Jobs Value})

Genevieve P.

Hi @Eric Goldsmith

It looks like there are a few syntax errors here that we can iron out. For the CRITERIA portion after the first range, we need to state that you're looking for the MONTH in each cell (@cell) of that column to see if it equals today's month.

MONTH(@cell) = MONTH(TODAY())

However we can sometimes get errors with the MONTH function if there are blank cells in the range, so lets add an IFERROR statement, like so:

IFERROR(MONTH(@cell), 0)

Try this:

=SUMIF({Actual Completion Date}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Completed Jobs Value})

Let me know if this works!

Cheers,

Genevieve