SUMIF
in [General]
|
Prev: excel cells changing to "#VALUE!" whenever another file is opened
Next: I am having troubling opening an excel document.
From: Orange Fuel Orange on 9 Mar 2010 20:22 I have two columns. First column contains dates, second column contains numbers. I want to sum all numbers for a specific month and year (i.e. sum all cells with date of 12-2009) Thanks.
From: T. Valko on 9 Mar 2010 23:21
One way... Use cells to hold the dates of your boundaries. D1 = lower date boundary = 12/1/2009 E1 = upper date boundary = 12/31/2009 Column A contains the dates Column B contains the values to sum =SUMIF(A1:A20,">="&D1,B1:B20)-SUMIF(A1:A20,">"&E1,B1:B20) -- Biff Microsoft Excel MVP "Orange Fuel" <Orange Fuel(a)discussions.microsoft.com> wrote in message news:3B23242E-6330-4FB2-8A56-6E994C0301F7(a)microsoft.com... >I have two columns. First column contains dates, second column contains > numbers. I want to sum all numbers for a specific month and year (i.e. > sum > all cells with date of 12-2009) > > Thanks. |