Sum columns if adjacent columns match if statements in Google Spreadsheets

Question

I have to sum column A if adjacent column B is within a particular range. Here's what I mean:

Sheet 1

   A   B
1  $2  November
2  $5  November

Sheet 2
   A
1  for each B1:B where the cell = November, sum adjacent A (my result should be $7)
2

Is there a way to do this in Google Spreadsheets?

score 1 · Accepted Answer · answered Jun 29 '15 at 23:39

1

Does this formula work as you want:

=SUMIF(B:B,"November",A:A)

answered Jun 29 '15 at 23:39

Chris Hick

Yep, this is great! Future people: I ended up having to use SUMIFS because I had multiple conditions. Interestingly enough, the Google Docs documentation doesn't include a link to SUMIFS from the SUMIF page. – Ringo Blancke Jul 01 '15 at 21:29

1 Answers1