Using 2003 for awhile now, but running into a brick wall. Have a client with an inventory workbook with 156+ worksheets. Each sheet represents an artist with columns of: title & medium, size, received, date, price, date sold, invoice, paid, comments, balance, type. There is a summary sheet we created to show how much is in inventory for each artist. That was easy enough. Just ran a total on each worksheet, then had the summary sheet read that worksheet and cell.
Now we need to figure out year to date sales for each artist. I have been searching the Internet and my Excel 2003 for dummies book, but no luck on how to pull up that info. The summary sheet shows only the artist name, amount in inventory, and year to date sales. I want to be able to tell the summary sheet to read the artist sheet for a date sold range, then pick up the paid amount. One problem is that inventory that came in two or three years ago might not sell until this year, so there are varying dates in the database. I think I need to SUMIF or COUNTIF my PAID column (which is a dollar amount) and the IF would be if the range of DATE SOLD column is between 1/1/06 and 12/31/06, but I can't quite make it over the hurdle. If there is anyone out there who can help, I would greatly appreciate it.
I have a table that was created in Word 2000 that has been copied into Excel
2000. There is a column (A) that contains a list of countries and I would
like to count the number of times each country appears in column A. In Column
B I typed =countif(a1:a20,"Japan") and the value is returned.
The problem is that some cells in column A contain more than one country,
for example Japan, Italy. If I use 'countif' it returns the value as zero. Is
there another formula I can use?
The desired results is to determine how many times the country is repeated
and then to generate a chart based on the results. This is all text and other
than the 'tally' there are no numbers involved.
Any help would be appreciated.
37 New Custom Functions For Excel. No spyware or malware.
37 New Custom Functions For Excel
Occasionally I type in a simple function or formula such as =AA7 and Excel
treats it like a literal instead of a function. If I open another
spreadsheet and type in the same formula it correctly gives me the value of
cell AA7.
Any clues.
HI,
is it possible to export all Functions/Formulas/Validation list formulas etc. for each cell for an Excel Workbook? Would be useful as a backup and/or reference for everyhing a given Cell in the Worksheet is holding (in case of multiple things).
Joe
I am curious if there is a way to calculate the days per year if given a span of time. For example, if I have a starting date of 1/1/2007 and a finish date of 1/1/2009 with "Starting Date" and "Finish Date" as seperate columns, is there a way to calculate the days per year that fall into that time span??
Thanks in advance!!!
Hi Guys,
I am trying to make the below code snippet work to return a date if all arguments are positive. Unfortunately, instead of returning the date, this function returns "". Is there something small I have missed out here?
Should I rather use .FormulaR1C1 = "=TODAY()"? Or is this because I have tried to do the Date function within a WITH statement.Interior?
'If rejected and resolved return todays date
If Left(Cells(ifindrow, iColNum(8) - 1).Value, 3) = "Rej" And Cells(ifindrow, iColNum(8)).Value = "Yes" Then
With Cells(ifindrow, iColNum(8) + 1).Interior
.ColorIndex = xlNone
.Value = Date
End With
End If
Many thanks for your consideration.
Kind Regards,
Stefan
Is there a function in excel that provides the number of distinct periods (i.e. days, weeks, months or years) between two dates?
I have the word "August" in cell C3. I would like for cell I3 to be "September" based on the value in cell C3, and I would like cell O3 to be "October" based on the value in cell I3. Seems like it shoud be simple to convert it to a date format in an Excel function and add a month, but after trying too long and searching mrexcel.com, I can't seem to find a way. Also, I need to use Excel functions, not VBA. Any help would be appreciated. Thanks.
