# Calculating Yesterday's Accounts Closed

Options
✭✭

Hi,

I'm trying to design a formula that calculates the total number of accounts completed by my staff. The formula that I'm using comes back as "Unparseable". Please take a look and let me know what I'm doing wrong. Thank you. =sumif(WORK DATE:WORK DATE, WORK DATE @row= TODAY(-1), ACCOUNTS CLOSED: ACCOUNTS CLOSED)

• ✭✭✭✭✭✭
Options

What does this do?

=SUMIFS([ACCOUNTS CLOSED]:[ACCOUNTS CLOSED], [WORK DATE]:[WORK DATE], @cell = TODAY(-1))

If this still throws the same error, double check your column names. Smartsheet hides more than one consecutive space, so if you have (for example) two spaces between Accounts and Closed, it will display as a single space but will not be considered valid if you do not include that second space in your formula.

• ✭✭
Options

Perfect! Thanks much!!!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

• ✭✭✭✭
Options

Hi,

Try the below formula:

=SUMIF([WORK DATE]:[WORK DATE], [WORK DATE]@row = TODAY() - 1, [ACCOUNTS CLOSED]:[ACCOUNTS CLOSED])

Thank you!

• ✭✭
Options

Hi Paul,

It still comes back as Unparseable.

• ✭✭✭✭✭✭
Options

What does this do?

=SUMIFS([ACCOUNTS CLOSED]:[ACCOUNTS CLOSED], [WORK DATE]:[WORK DATE], @cell = TODAY(-1))

If this still throws the same error, double check your column names. Smartsheet hides more than one consecutive space, so if you have (for example) two spaces between Accounts and Closed, it will display as a single space but will not be considered valid if you do not include that second space in your formula.

• ✭✭
Options

Perfect! Thanks much!!!

• ✭✭✭✭✭✭