Conditional addition

[CanadaDBA]

Hi,

I want to sum numbers in column B if corresponding date in column A is between Jan and Mar. For example in the following table, the formula should sum Jan line and Feb line and the result would be 12 + 55 = 67.

A					  B
-----------		  ------------------
24-Jan-06			12
19-May-06		   78
13-Dec-06		   40
01-Jun-06			32
07-Feb-06			55

Thanks,

Edited April 11, 2007 by CanadaDBA

[NukedWhale]

First convert your dates to numbers using =datevalue

Then figure out the date values for the necessary date range

Create a column C which will store the numbers to sum that are in the acceptable date range

Then in column C create a formula along the lines of =if(minimum date value=<your date value=<maximum date value,the number to be summed,"")

Drag and fill and then sum all the numbers in column C

[spacesurfer]

easiest way is to use the conditional sum wizard in excel. it will walk you through it.

it's found in tools --> conditional sum...

If you don't see it, you'll have to install add-ins. Go to tools, add-ins, then check conditional sum wizard.

or you can do it manually as mentioned in post 2. the wizard is helpful for complex conditions.

[NukedWhale]

Do you know where we can find this conditional sum add-on?

[spacesurfer]

I thought it was part of Office as an "add-on". You don't see it?