One formula works in a cell and same formula does not work in another cell.

Copper Contributor

I am trying to sum values from different cells that are in a certain date range.  I used a formula that works for one cell on one page.  Although, the same formula shows 0.00 on a different page.  Why isn't the formula working on all pages?

This is the formula I'm using:

=SUMIFS(U1:U4000,Q1:Q4000,">="&DATE(2024,1,1),Q1:Q4000,"<="&EOMONTH("JANUARY 1, 2024",0))

 

1 Reply

@B_HALEY71 

Why don't you use:

=SUMIFS(
  U1:U4000,
  Q1:Q4000,">="&DATE(2024,1,1),
  Q1:Q4000,"<="&DATE(2024,1,31)
)