Hello, I have looked through the threads and believe what I require is the SUMPRODUCT function. I have a spreadsheet with column A containing dates in the...

I have a spreadsheet taht contains many v-lookups. When no match is returned, it displays a #n/a. If this is displayed in a range that is sumed up, if causes...

If I have a column with some repeated numbers: 58 168 168 25 .... How could I count the cells from the column to get 3 (not 4) as a result - to be able to...

I need a formula to count the number of records meeting a criteria in a pivot table. Since the column in the pivot table that contains the data to look at may...

I would like my vlookup function to look for a value in one sheet and if it doesn't find it, look in another sheet. Is this possible? I was considering using...

i have a spreadsheet called "complaints" and one of the column headings is "status". the response is pending or resolved. now this is what i would like to do....

From another post I found a formula to automatically number a cell if there was data in the cell next to it (for example, if there's data in D5 in...

I am trying to count two colums if they both meet/match a curtain number. Example if A1 = 2 and B1 = 12 then add one to the count. The array that I am trying...

I faxed a worksheet tab directly from within excel and now when I try to print, the printer runs but only a blank sheet of paper is produced. Can anyone tell...

I'm trying to get a formula result to return the value in the last filled row of a column on a worksheet in another book. I've used "LASTINCOLUMN" before, but...

column A non unique dates in ascending order column C either a value greater then zero or blank column N either "upgrade" or blank column R a number I need to...

I have a Column that is currently set up as follows: jones john & sharon I want to divide the column and make two colums like: Column one = Jones Column...

cell m2 refers to a letter determined by a formula.(for exmple D or F). cell i10 uses the following formula with a cell reference to another sheet. I need the...

Would appreciate any form of help. After setting up a pivot table (in a separate worksheet from the data sheet), I copied and pasted that first pivot table a...

How do I make a report in Excel? I'm so accustomed to doing it in Works 4.5 and its easy there, but I need it in Excel. Is there a tutorial I can d/l? thanx.

Is there any software available for bookkeeping?

Hi gang: I need a formula to return results ONLY if the results of the formula in an adjacent cell are not blank. I hope this is enough information for...

I think that MS EXCEL 2003 should have a simpler formula to subtract numbers versus it's current one that requires a minus sign after every cell reference. ...

Given a data base with first & last names in one column. How do alphabetize with last names first, and first names last?