HI, I am tryng to use the SUMPRODUCT a following to sum ammount in column "A" which take into account criteria in columns "B" and...

I am a new macro user. I have read the tutorials but cannot get the macro to work. I use Excel 2000. Each time I run the macro it wipes out earlier data. ...

hi, I have a drop down box in a cell. Based on a value of anohter cell I have to fill my drop down box. what i mean is, say if GreeNPackage is "No" then I...

Product: Excel 97 SR-2 I know that if I right-click on a worksheet tab, and click the 'View Code' option, a VB editor shows up and I can enter the...

Me again ... while I am here ... My spread sheet contains a first column with unique values and the remainded of the colums are referenced in another...

I have used the sum command in Excel 2003 and it keeps calculating the wrong total. any suggestions.

I mistakenly saved a worksheet on top of the wrong one. Is there anyway of restoring the old one that has been written over? thank you

WHY IS MY DATE FORMATTED COLUMN SHOWING A FIVE DIGIT NUMBER? Eg: 24-Nov-04 is showing as 38317

CAN I INSERT ROW OR COLUMN WHILE USING IF FUNCTION THANK YOU

I have a monthly report from a data warehouse which will have addditional suppliers periodically reported alphabetically - thereby changing the col index no of...

Having calculated a Trend Line how do I get the trend line data back into a spreadsheet from the chart. ie I've calculated sales over 12 months,...

anyone fancy trying to solve an excel problem for me ? i have 5 cells in a row. A B C D Z if there is a value in A and a value in B, then B should appear in...

Hello... I am trying to make a spreadsheat that will stop users from entering an entry already entered. I have a Serial # column... these serial #'s can be...

I am trying to get total of hours worked useing military time.... time start time stop total hours 11:34 16:47 ...

Hi Bob please help!!!!! it did not work.This is a example of what I want to do Date In Out Lunch Total Hours...

Hi, I'm sure this is a simple one, but my one remaining brain cell can't see it! My formula currently is:- =COUNTIF('FLYING TIMES'!F4:F22,"W") What I...

Thanks for all the previous assistance... however I have now encountered another couple of problems Again back to my large spreadsheet issues ... I have...

I need to count a number of entries that are between two dates where that data is stored in column A and also if the text value in column F is "yes". I have a...

Does Sumproduct work with range names or are there restrictions? Like no blanks, etc. When I use range names I get #NUM This is a very helpful group. I even...