Help with SUMIFS

%3CLINGO-SUB%20id%3D%22lingo-sub-2577844%22%20slang%3D%22en-US%22%3EHelp%20with%20SUMIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2577844%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20where%20Column%20A%20has%20dates%20and%20Row%201%20has%20headers.%20All%20other%20cells%20have%20values.%20I%20need%20to%20sum%20the%20values%20for%20all%20cells%20between%20Columns%20Q%20and%20GZ%20that%20meet%202%20criteria%3A%20date%20in%20Column%20A%20must%20equal%20TODAY()%20and%20header%20in%20Row%201%20must%20contain%20a%20specific%20string%20%22xxx%20xxxx%22.%20I%20have%20tried%20the%20formula%20below%20but%20it%20is%20not%20working%20and%20I%20cannot%20figure%20what%20is%20wrong.%20Please%20help.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUMIFS(Q%3AGZ%2CA%3AA%2CTODAY()%2C1%3A1%2C%22*xxx%20xxxx*%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2577844%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2577965%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20SUMIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2577965%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F571863%22%20target%3D%22_blank%22%3E%40alanbr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETake%20a%20look%20at%20the%20online%20help%20for%20SUMIFS()%3A%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CSPAN%3EThe%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CI%3ECriteria_range%3C%2FI%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bargument%20must%20contain%20the%20same%20number%20of%20rows%20and%20columns%20as%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CI%3ESum_range%3C%2FI%3E%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bargument.%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2577983%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20SUMIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2577983%22%20slang%3D%22en-US%22%3EIf%20SUMIFS%20does%20not%20work%2C%20any%20ideas%20of%20how%20I%20can%20get%20the%20job%20done%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

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*")

3 Replies

@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.

 


 

If SUMIFS does not work, any ideas of how I can get the job done?

@alanbr 

You can always try SUMPRODUCT().

 

Untested!

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