|
|
help with SumIF by
Radeesh
Hi
I have some dates in Col i and ammount in Col j
I want use SumIf to add all the amounts in a given month
=SUMIF(MONTH(I4:I13),MONTH(B20),J4:J13)
this is...
|
September 16th, 2003 12:17 PM
by Radeesh
|
4 |
339 |
|
|
|
September 16th, 2003 12:21 PM
by Anon
|
1 |
572 |
|
|
Balanced Scorecards by
Tom
I am certain if this is the right newsgroups for my
questions, but maybe I'm lucky and someone can provide me
some pointers.
Currently I'm doing research on...
|
September 16th, 2003 12:44 PM
by bock
|
2 |
485 |
|
|
Columns now numbers????? by
Sandra Britcher
Why are my columns now numbered at top rather than
letters. Calculations WERE easy, now it is a major
undertaking to get even simple calculations. How...
|
September 16th, 2003 02:08 PM
by Allen
|
2 |
520 |
|
|
macro question by
Joe Silvers
Is there any way to create a macro in Excel that will go
to a cell, wait for you to enter data and hit return, go
to another cell and repeat this process. I...
|
|
1 |
465 |
|
|
Calculating Time by
Duane Emerson
I'm trying to add & divide hours that exceed 24. Ex: I
work on a particular project 5 hours a day Mon - Fri. I
would like to total the hours, then divide by...
|
|
2 |
357 |
|
|
formula by
Tim
Hello All,
I need help with a formula that multiplies two cells. The
first numberis the actual cell, but the second number
refers to a cell with a cell...
|
|
1 |
332 |
|
|
crore formatting by
kaushik
I want to format a range of cell/ a entire column in crore
format i.e 1,00,00,000.00 and also want to sum that entire
column.
I tried it with "fotmat cell"...
|
|
1 |
286 |
|
|
Pivot table - formatting by
akk
Hi Anon,
That option was ticked. Despite that, the formatting
changes.
-----Original Message-----
"akk" wrote in...
|
September 16th, 2003 03:35 PM
by akk
|
0 |
464 |
|
|
Lookup question by
FBC
I'm trying to compile a database based on info from
another databse. I would like to take only the rows that
contain a certain value in a cell to make the...
|
|
1 |
266 |
|
|
Pop up function ??? by
MsSwiss
I am creating an excel document that several people will
use. I am using a pivot table in one of the sheets and I
would like to have a pop up or a callout that...
|
September 16th, 2003 04:18 PM
by Andy B
|
2 |
304 |
|
|
IF cell contents = ????? by
HeatherM
I want to count the instances of each value in a column
with various references in it(a mixture of text entries
and number entries). I would normally put an IF...
|
September 16th, 2003 04:18 PM
by Ed Lisay
|
1 |
634 |
|
|
Index & Match by
Greg Malenky
excel 2000
I am having trouble finding the proper function to arrive
at the following answer for this table:
employee store
john store1
dave ...
|
|
2 |
656 |
|
|
Newbee show cell address by
Microsoft Newsgroups
I am having difficulty tranfering from C to VB.
How can I assign, pss, or MsgBox the string address of a particular cell.
If I use
Dim cellref as...
|
|
2 |
387 |
|
|
If value is greater than, then.... by
Robert
Hi,
I am trying to create a formula. Column A has a number
Column B is a sum of A*1,2 only if A is over 100 otherwise
B=A
Logic: If A1100 then B1=(A1*1,2);...
|
|
5 |
283 |
|
|
Entering numbers by
Jorr
I'm entering long numbers on an Excel 2000 spreadsheet in
a cell set for number format. When I enter a long number,
such as a credit card number (16 digits)...
|
September 16th, 2003 05:25 PM
by FBC
|
1 |
428 |
|
|
Choice and effect by
Gerry Kuta
From within A1 which contains the text Area 1;Area 2;Area
3; Area 4 I'd like C1 to display Area 1 if in B1 I enter
1. (Area 2 on entry of 2 in B1 etc.)
From...
|
|
1 |
334 |
|
|
Pivot table update by
aablank
I have a number of pivot tables based on the same data
worksheet. Right now when I add more data, I have to go
to each table and update the range manually. ...
|
September 16th, 2003 06:46 PM
by aablank
|
3 |
470 |
|
|
calculating with displayed values by
Tobit
I have two cells, each displaying numbers to with 2 decimal points
Cell A1 contains the number 15.333333333 (the figure the result of a
calculation)
Cell A2...
|
September 16th, 2003 06:57 PM
by King
|
9 |
452 |
|
|
|
|
2 |
298 |