Forum Discussion

Copper Contributor

Nov 01, 2025

Imported data pertaining to date not working with SUMIFS

I have been struggling to get SUMIFS to work by returning an amount based on two criteria, name of customer and date range for invoices within a calendar month. Here is the formula: =SUMIFS(ActRevM...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Nov 05, 2025

Most probably

=SUMIFS(
   ActRevMth[Amount],
   ActRevMth[Name], Revenue!B13,
   ActRevMth[Date], ">="&Revenue!E3,
   ActRevMth[Date], "<="&Revenue!F3
)

shall work