I've searched various posts and need the straightforward answer to summing a column with various criteria from other columns.

Hypothetically, I'm working to sum various numbers/amounts in Column A with criteria in Column B and C and maybe D. Column B would be a date. Column C would be a text cell, i.e. "C1". Column D could be another text field.

I've attempted to work with SUMIFS but am likely confused. My gut tells me this might be an Arrayformula, but I get a bit crossed up. Your help is appreciated.

CodePudding user response：

The simplest solution is to make a pivot table without any calculation.

Group dates by year-month