SUMIFS Formula with multiple criteria excluding blanks

B Young

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?

KPH

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

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

KPH

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

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

KPH

Glad I could help.