SUMIFS Formula with multiple criteria excluding blanks

I would like to sum a column, only if another column with dates falls between certain dates, and if another column with dates is not blank. I have the first part of the formula sorted but can't get the part to include if another column is not blank. The formula I have is:

=SUMIFS({Area (m2)}, {Del Date}, >=[Start Date]@row, {Del Date}, <=[End Date]@row)

The formula needs to include if the payment date is not blank.

Hope this makes sense?


Best Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    Hi @B Young

    You can add another range and criteria

    {Payment date reference}, <>""

    Where Payment date reference is whatever you name your cross sheet reference to the payment date column.

    =SUMIFS({Area (m2)}, {Del Date}, >=[Start Date]@row, {Del Date}, <=[End Date]@row,{Payment date reference}, <>"")

  • B Young
    B Young ✭✭
    Answer ✓

    Thank you! This has solved the question - appreciate your prompt response.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!