|
|
|
|
1 |
100 |
|
|
Sumproduct, By Quarters and Amount by
Tom Fortune
I have been trying to use SUMPRODUCT to count the number of data entries that
are less than 23 (column F) by quarter (date is in column C). I can't seem
to...
|
|
5 |
93 |
|
|
|
|
9 |
306 |
|
|
Newbie needs a function (how sad) by
tjr
I am trying to create a function in a checkbook register type workbook that
will do the following:
if name in column a = x and date in column c = y then add...
( 1 2)
|
|
12 |
149 |
|
|
Date? by
Ken
Excel 2000 ... I have a date (01/01/05) in cell V1.
In 12 other cells I would like to put formula that will
give me months of year January, February, March...
|
January 24th, 2005 11:51 AM
by Ken
|
3 |
112 |
|
|
vlookup to other files by
Brad
I have a worksheet that has vlookup formulas that refer to another file. If
this file is a semicolon delimited file, do I have to have it open for my
master...
|
January 24th, 2005 02:39 PM
by Brad
|
0 |
76 |
|
|
|
|
0 |
83 |
|
|
Formula to Calculate Age by
Tabitha
I have an age column and a DOB column, What is the formula to calculate the
age by using the date of birth.
|
January 24th, 2005 04:09 PM
by Tabitha
|
2 |
195 |
|
|
placing files into Quark by
atsdaisy
Hi there. I have our price book set up in Excell. There are patterns and
underlines that are in the Excell file that ARE NOT copying into Quark. I
use...
|
|
0 |
67 |
|
|
|
|
1 |
217 |
|
|
Countif problems by
Sony
I am entering the following =COUNTIF(AC5:AI150,"True"). Basically, what
happens now is Excel is creating a Circular referance, I had this working on
another...
|
|
6 |
117 |
|
|
Totaling Cells in Worksheets by
Jim
Need some help guys. I have a spreadsheet with data that
totals and then within the same worksheet I have a
summary of the totals. Example: I have a cell with...
|
|
1 |
82 |
|
|
|
|
4 |
121 |
|
|
Concatenate errors by
reno
I use a form that includes lookup tables. one of the lookup tables contains
financial accounting dates, e.g.,week 1 on lu table is 01/03/05 and 01/07/05
then...
|
|
1 |
70 |
|
|
Problems with IF function by
Jig Bhakta
When I try to use the IF function and try to say that if a cetain cell has a
value of N/A, the value of this cell should be 1, otherwise it should be...
|
|
1 |
272 |
|
|
Average Function help by
Cheech
I'm curious to whether or not this particular action that I'm trying
make happen is possible w/o the aide of macros.
The problem is that I'm trying to take...
|
January 24th, 2005 10:11 PM
by Max
|
5 |
90 |
|
|
Using VLLOKUP by
Cessna12
When I enter the function in a cell, the result is correct in the set up.
When I hit enter, the only thing taht is up into the cell is the VLOOKUP
formula and...
|
|
3 |
102 |
|
|
|
|
1 |
645 |
|
|
Formatting Sub Totals by
KS
On Excel 97, when you subtotal on one column and then subtotal on a second
column, it puts the first group's subtotal below all of the subtotals for the
second...
|
|
1 |
114 |
|
|
How do I sort multiple pages with headers by
donnr11
I have office 2003. I have a list of names and titles that is 19 pages long.
1000+ entries. I have headings on page one and have sorted it by the 3
different...
|
|
2 |
219 |