I am trying to set up a time card that I downloaded from the templates page on MS. I like the format of the one that I have, but this is what I want it to...

When I change a number in one of the cells the result won't change when I click "enter'". (this is in addition)

Hi, In col B are dates in col F are the amounts paid. in A1 I want to create the average months income. Generating the avearge using the part of the month...

This formula works as long as it is not located within A1:I9 =SUMPRODUCT(--((A1:C3:D4:F6:G7:I9)="Y")) Does that help? *********** Regards, Ron

I typed =IF($Q23="A",$O23,(IF($Q23="W",$O57,""))) into the formula bar. I think the formula is valid. Basically, I want the value in cell O23 to show if "A"...

I followed most of the post recently on the subject of list and combo boxes. From what I can tell I need to create a list but I need to have the list find the...

I work in a library and want to sort lists of CD titles. I want to sort the list alphabetically while ignoring articles (e.g., the, a, an) when they appear as...

I have a workbook that is set up that when I enter a specific value ex:e18 in one cell it will give me the coresponding number ie:800-252-6030 in a different...

=SUMPRODUCT(COUNTIF(INDIRECT({"A1:C3","D4:F6","G7:I9"}),"Y")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Kurt Swanson"...

wont excel install an need help reinstalling xp2 need code -- sandra fennell ---------------- This post is a suggestion for Microsoft, and Microsoft responds...

I cannot get COUNTIF to work with a non-contiguious range in my XL97, but if this is something you have to do frequently, you may be interested in the "List ...

thanks to some members of the forum i now have drop down lists on my spreadsheet, however... i have to input say 20 peoples information in a month and i...

i'm working on a spreadsheet, and i have 49 headings that should be filled in. i have sorted them in to sections, that fit under a group heading. i would like...

I have a substantial excel spreadsheet with 10 columns of simple text/figures, and I need to frequently lift the data from a single row and display it...

I'm doing revision of my exam and I don't understand about Lookup function, what's this function for?? When I read the instruction aboout "Lookup" on my...

I m using =SUMPRODUCT(--(MONTH(b7:b400)=MONTH(D417))) this function to locate particular month's sale from my sale book, but when i change only year it does...

$x eg $10 can be replaced normally by $11 but when used with the counter i ( i=i+1) 11 is returned and can be replaced seperately to $11. This occurs whether...

How to you resolve this, An XML mapping cannot be exported if the mapped element’s relationship with other elements cannot be preserved. This relationship...

Folks, I’ve spent a fair bit of time perusing this and other groups. Two things were very apparent to me. First, I don’t know much! Second, I’m so...

I'd like to create an array to place values in column A into Column B and remove blank cell from column A. Example:data in column "A" has blank cell at A2,...