Forum Discussion
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...
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?
You can always try SUMPRODUCT().
Untested!
=SUMPRODUCT((A:A=TODAY())*COUNTIFS(1:1;"*xxx xxxx*")*Q:GZ)
