Argh, anyone good with Excel?

[RagingBITCH]

I'm trying to create a report. Well basically I have 3 columns:

Start Date | End Date | Current Daily Revenue
1/2/2006 | 6/23/2006 | $952.00
etc. on the data


Basically I have to create a report dating back through December on our daily revenues.

Now I originally use the SUMIF function to calculate the function. It worked but it only checked to see if the date for that report (say 2/1/2006) was less than or equal to the end date.

Considering I have to build it up through this past December that doesn't really work. I'm kind of stumped as to how I could check two dates and columns at one time. IE, today's date, 2/6 - it has to be less than the current end date and greater than a start date for the current daily revenue to be summed up. IE, if there was data in there stating 2/30/2006, then that day's revenue would not be summed up.

SUMIF only seems to work with one criteria/condition. I'm stumped. Any ideas?

========================================
You should have known better where to post such a question.

I have moved you to the correct forum. (One time chance only )

Mod

Are you going to spank me if I'm bad again? *bends over*

 

[Juice Box]

If you click on the little equal sign, it will give you a "formula wizard" which, IIRC, will let you add more variables to the SUMIF command

 

[EagleKeeper]

S/W =====>

 

[giantpinkbunnyhead]

Originally posted by: RagingBITCH
I'm trying to create a report. Well basically I have 3 columns:

Start Date | End Date | Current Daily Revenue
1/2/2006 | 6/23/2006 | $952.00
etc. on the data


Basically I have to create a report dating back through December on our daily revenues.

Now I originally use the SUMIF function to calculate the function. It worked but it only checked to see if the date for that report (say 2/1/2006) was less than or equal to the end date.

Considering I have to build it up through this past December that doesn't really work. I'm kind of stumped as to how I could check two dates and columns at one time. IE, today's date, 2/6 - it has to be less than the current end date and greater than a start date for the current daily revenue to be summed up. IE, if there was data in there stating 2/30/2006, then that day's revenue would not be summed up.

SUMIF only seems to work with one criteria/condition. I'm stumped. Any ideas?

========================================
You should have known better where to post such a question.

I have moved you to the correct forum. (One time chance only )

Mod

Yes. Excel has a conditional sum wizard which lets you run a sumif with up to 3 criteria. It will be in your tools menu. If you don't see it there, go Tools->Add-Ins and you should be able to "install" it.

When you have all your data entered into your sheet, run this wizard and follow the steps and it'll create the formula for you.

 

[RagingBITCH]

Ahh I wasn't aware of the Conditional Sum Wizard. It's not working entirely correctly right now but it's the right track. Thanks