Recent content by Steve4321

One more question, is there a faster way to get the same results? I have 8 SUMPRODUCT formulas on this work sheet and it takes 25 seconds to calculate. I know that there is probably a better way. Thanks, Steve

Came across this online somewhere, I don't know if it will work in 2000 or not. Hit Alt+F11 to open Visual Basic editor. Click "Insert" then "Add Module". Put this code in side of the module. You can change shapes and effects by changing the msoShapeRectangle and msoAnimEffectPathZigzag, try...

To all, Thank you everyone for your help. Turns out my problem was one column of data formated as text instead of numbers. Spreadsheet works great. Steve

Brad, I put in the formulas exactly as you have them and I am still getting a 0 for sum. These are the formulas that I've tried. =SUMPRODUCT((Shop=A2)*(MONTH(Date)=MONTH(B2))*(YEAR(Date)=YEAR(B2))*ProdTot) =SUMPRODUCT((Shop=A2)*(MONTH(Date)>=MONTH(B2))*(YEAR(Date)<=YEAR(B2))*ProdTot) Whenever...

Go to Insert on your menu bar, select Hyperlink and browse to the web page or directory that you want. Above the folder drop down list is a bar that says "Text to display". Type in whatever you want to and send the e-mail. Hope this helps.

Frank, You can also select "Handouts" in the print setup and set the number of slides to 3. Sending the presentation to Word does give you many more options, including printing out any notes along with the slides.

Geoff, Thanks for your input. I hard coded the ranges and the errors are gone but the answer it gives is 0. Again I made sure that the range lengths were the same and tried the formula both ways, ()*() and --(),--(). Will a 0 in some of the cells cause this problem? I double checked the...

Ken,Skip and Blue; Thank you for your help on this problem. I researched the SUMPRODUCT function and it is the one I am looking for. The problem that I am having now is that SUMPRODUCT is giving me a different fault depending on how I put it in. I think that this may have to do with my dynamic...

A B C D E F Month Shop Prod1st Prod2nd Prod3rd ProdTotal 01/03/04 6140 750 675 0 1425 01/05/04 7210 450 475 500 1425 01/06/04 6140 675 700 0 1375 02/10/04...

I am a new user and have encountered a problem with a spreadsheet tracking productivity. I have tried several different ways to get the information I need but keep falling short when I try to sum using a "From" "To" date range. My spreadsheet is laid out basically as follows: A B C...