Total invoiced within a date range

Rotisol

Hello, in my example attached we are looking to incrementally add the "PO total amount" invoiced as we will add more rows. We need to add for the first quarter so dates going from 1/1/25 to 3/31/25….we are trying to use that formula but not working:

=SUMIFS([PO total amount]:[ PO total amount], [PO’s date]:[ PO’s date], >=DATE (2025,1,1) , [PO’s date]:[PO’s date], <= DATE (2025,3,31))

thanks for any help!

Carson Penticuff

Okay… so a couple of issues.

There are some extra spaces in your formula:

[PO’s date]:[ PO’s date] | Notice the extra space before PO in the second set of brackets.

DATE (2025,1,1) | There should not be a space between DATE and the opening parenthesis.

Here is the formula with the spaces fixed:

=SUMIFS([PO total amount]:[PO total amount], [PO’s date]:[PO’s date], >= DATE(2025,1,1), [PO’s date]:[PO’s date], <= DATE(2025,3,31))

If ↑↑↑this formula↑↑↑ works, you can ignore the rest, if not, keep reading.

The second issue is the apostrophe. The apostrophe in your formula is not the "standard" apostrophe. It really doesn't matter which apostrophe you use as long as you match those used in the column names to those used in any formulas. It is impossible to tell from your screenshot which "version" is used in the column names.

The is the apostrophe in the formula you posted: ’

This is the "standard" apostrophe: '

Visually, the difference is pretty subtle, but they are completely different characters.

Here is the formula with the spacing fixed and replacing the apostrophes:

=SUMIFS([PO total amount]:[PO total amount], [PO's date]:[PO's date], >=DATE(2025, 1, 1), [PO's date]:[PO's date], =DATE(2025, 3, 31))

I hope this makes sense, it is a difficult concept to explain. I will be more than happy to attempt to clarify, if needed.

Carson Penticuff

Okay… so a couple of issues.

There are some extra spaces in your formula:

[PO’s date]:[ PO’s date] | Notice the extra space before PO in the second set of brackets.

DATE (2025,1,1) | There should not be a space between DATE and the opening parenthesis.

Here is the formula with the spaces fixed:

=SUMIFS([PO total amount]:[PO total amount], [PO’s date]:[PO’s date], >= DATE(2025,1,1), [PO’s date]:[PO’s date], <= DATE(2025,3,31))

If ↑↑↑this formula↑↑↑ works, you can ignore the rest, if not, keep reading.

The second issue is the apostrophe. The apostrophe in your formula is not the "standard" apostrophe. It really doesn't matter which apostrophe you use as long as you match those used in the column names to those used in any formulas. It is impossible to tell from your screenshot which "version" is used in the column names.

The is the apostrophe in the formula you posted: ’

This is the "standard" apostrophe: '

Visually, the difference is pretty subtle, but they are completely different characters.

Here is the formula with the spacing fixed and replacing the apostrophes:

=SUMIFS([PO total amount]:[PO total amount], [PO's date]:[PO's date], >=DATE(2025, 1, 1), [PO's date]:[PO's date], =DATE(2025, 3, 31))

I hope this makes sense, it is a difficult concept to explain. I will be more than happy to attempt to clarify, if needed.

Rotisol

Thank you Carson!

First formula did not work so I used the updated one with the "apostrophe"…and it worked. Much grateful.

Ah! I am going to let this "apostrophe" concept be part of the Smartshseet mysteries…but I am sure it is fascinating when you understand the intricacies :-)

Carson Penticuff

Excellent, I'm glad it worked for you!