SUMIF based on 2 columns instead of 1?

  • Thread starter Thread starter barbetta3141
  • Start date Start date
B

barbetta3141

I have columns Person ("Adam", "Bob", "Charlie"), Day ("Monday",
"Tuesday", etc), Total. I'd like to SUMIF based on BOTH Person and Day
(e.g. sum for "Bob" and "Tuesday"). I'd rather not use PivotTables,
because (1) this is pretty simple and (2) people here are scared of
PivotTables. Can i use SUMIF based on 2 columns, either by
concatenating the text or with an array? Thanks.
 
Hi there,

Try something like ..

=SUMPRODUCT((A1:A100="Bob")*(B1:B100="Tuesday"),C1:C100)

Where column A has your names, column B has your days and column C has the
associated value you wish to sum.

HTH
 
You can use SUMPRODUCT, e.g.

SUMPRODUCT(--(A2:A100="Bob"),--(B2:B100="Tuesday"),C2:C100)
 
Have you tried an array function, something like

=(SUM((A1:A3="Bob")*(B1:B3="Tuesday")))

then use ctrl shift enter to set it as array
 
Back
Top