J jenwren New Member Sep 21, 2012 #1 I want to use a simple sumif formula to sum the numbers in one column based on if it says 'August' or 'September' in another. I've tried sumif(c:c,a:a="August") but this doesn't work, where am i going wrong please? Thank you.
I want to use a simple sumif formula to sum the numbers in one column based on if it says 'August' or 'September' in another. I've tried sumif(c:c,a:a="August") but this doesn't work, where am i going wrong please? Thank you.
J jasonc New Member Sep 21, 2012 #2 Hi there Assuming that the month is in column A and the values to sum in column C =SUMIF(A:A,"August",C:C) should give the result you're after.
Hi there Assuming that the month is in column A and the values to sum in column C =SUMIF(A:A,"August",C:C) should give the result you're after.
