Forum Discussion

alanbr's avatar
alanbr
Copper Contributor
Jul 23, 2021

Help with SUMIFS

Hi Everyone,

 

I have a table where Column A has dates and Row 1 has headers. All other cells have values. I need to sum the values for all cells between Columns Q and GZ that meet 2 criteria: date in Column A must equal TODAY() and header in Row 1 must contain a specific string "xxx xxxx". I have tried the formula below but it is not working and I cannot figure what is wrong. Please help. Thanks!

 

=SUMIFS(Q:GZ,A:A,TODAY(),1:1,"*xxx xxxx*")

Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jul 23, 2021

    alanbr 

    Take a look at the online help for SUMIFS():

    The Criteria_range argument must contain the same number of rows and columns as the Sum_range argument.

     

     

    • alanbr's avatar
      alanbr
      Copper Contributor
      Jul 23, 2021
      If SUMIFS does not work, any ideas of how I can get the job done?
      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Jul 23, 2021

        alanbr 

        You can always try SUMPRODUCT().

         

        Untested!

        =SUMPRODUCT((A:A=TODAY())*COUNTIFS(1:1;"*xxx xxxx*")*Q:GZ)

         

Resources