|
|
SUMIF testing two columns... by
lgarcia
HI,
I am tryng to use the SUMPRODUCT a following to sum ammount in column
"A" which take into account criteria in columns "B" and...
|
November 25th, 2004 07:55 PM
by duane
|
1 |
125 |
|
|
Creating a macro by
Macro Insite
I am a new macro user. I have read the tutorials but cannot get the macro to
work. I use Excel 2000. Each time I run the macro it wipes out earlier
data. ...
|
November 25th, 2004 11:08 PM
by JulieD
|
3 |
191 |
|
|
Filling drop down box by
hi,
I have a drop down box in a cell. Based on a value of
anohter cell I have to fill my drop down box. what i mean
is, say if
GreeNPackage is "No" then I...
|
November 26th, 2004 12:54 AM
by
|
3 |
123 |
|
|
Excel / VB help by
Andrew
Product: Excel 97 SR-2
I know that if I right-click on a worksheet tab, and click
the 'View Code' option, a VB editor shows up and I can
enter the...
|
November 26th, 2004 01:08 AM
by Andrew
|
6 |
364 |
|
|
|
|
1 |
193 |
|
|
Incorrect total by
Karen
I have used the sum command in Excel 2003 and it keeps calculating the wrong
total. any suggestions.
|
|
5 |
123 |
|
|
old worksheet by
TotallyFemale
I mistakenly saved a worksheet on top of the wrong one. Is there anyway of
restoring the old one that has been written over?
thank you
|
|
1 |
75 |
|
|
|
|
1 |
228 |
|
|
IF FUNCTION by
Chandrashekhar
CAN I INSERT ROW OR COLUMN WHILE USING IF FUNCTION
THANK YOU
|
|
1 |
95 |
|
|
|
|
1 |
337 |
|
|
Trend Lines (or Linest?) by
Martinaire
Having calculated a Trend Line how do I get the trend line data back into a
spreadsheet from the chart. ie I've calculated sales over 12 months,...
|
|
2 |
208 |
|
|
ANDIF (i think) by
chrisabberton
anyone fancy trying to solve an excel problem for me ?
i have 5 cells in a row.
A B C D Z
if there is a value in A and a value in B, then B should appear in...
|
|
4 |
103 |
|
|
text = text block by
rjmckay
Hello... I am trying to make a spreadsheat that will stop users from
entering an entry already entered.
I have a Serial # column...
these serial #'s can be...
|
|
4 |
116 |
|
|
Hours worked by
Keith Bowman
I am trying to get total of hours worked useing military time....
time start time stop total hours
11:34 16:47 ...
|
November 26th, 2004 07:07 PM
by LanceB
|
2 |
87 |
|
|
Please help Bob!!!! by
Darkct
Hi Bob please help!!!!! it did not work.This is a example of what I want to do
Date In Out Lunch
Total Hours...
|
November 26th, 2004 07:41 PM
by Biff
|
5 |
105 |
|
|
INDIRECT WITH COUNTIF by
Malcolm Austin
Hi, I'm sure this is a simple one, but my one remaining brain cell can't
see it!
My formula currently is:- =COUNTIF('FLYING TIMES'!F4:F22,"W")
What I...
|
|
2 |
91 |
|
|
COUNTIF ON 2 VARIABLES ?? by
Alan
Thanks for all the previous assistance... however I have now encountered
another couple of problems
Again back to my large spreadsheet issues ... I have...
|
|
4 |
112 |
|
|
|
November 26th, 2004 11:12 PM
by Max
|
4 |
232 |
|
|
Range Names by
wal50
Does Sumproduct work with range names or are there restrictions? Like no
blanks, etc. When I use range names I get #NUM
This is a very helpful group. I even...
|
November 27th, 2004 12:49 AM
by wal50
|
3 |
213 |
|
|
|
|
1 |
165 |