|
|
|
May 16th, 2009 09:23 PM
by noe342
|
0 |
366 |
|
|
SUMPRODUCT 00-Jan-00 by
Tufail
Hello,
I am using following formula, when Sheet = Payment cell D9:D1000 doesn't
match value = Clear error value is coming in $K614 00-Jan-00 which I really...
|
|
3 |
323 |
|
|
|
May 16th, 2009 05:34 PM
by John
|
2 |
342 |
|
|
|
|
0 |
256 |
|
|
IF Strikethrough by
lightbulb
Is there a way to have a formula not include a cell that the text has
strikethrough lines?
What I need is if $C$22:$C$375 = abc or = def or = ghi then sum...
|
|
4 |
251 |
|
|
|
|
2 |
237 |
|
|
Cell Colors by
lightbulb
I've noticed some worksheets that others have made where the cells are a
color different than the options from the drop down menu of fill colors in my
excel....
|
|
3 |
215 |
|
|
Conditional Formatting - Display a dash by
AuditIA
I must be doing something wrong - I can't get it to work. I typed in exactly
what it said in the HELP example, but it still doesn't work. I entered...
|
|
4 |
268 |
|
|
|
|
1 |
257 |
|
|
|
May 16th, 2009 04:19 PM
by Mark
|
3 |
234 |
|
|
|
|
1 |
247 |
|
|
|
May 16th, 2009 03:21 PM
by Bagia
|
6 |
297 |
|
|
SUMPRODUCT by
Tufail
Hello,
I want get date from Sheet "Payment" Cell add "C" but are not able to do so,
my formula and error is as under :
Case1: ...
|
May 16th, 2009 12:41 PM
by Tufail
|
1 |
248 |
|
|
Help with Formula by
Scott
I have an interesting request.
For this example, lets assume we have 5 columns. First column contains data
values. The 4 additional columns are blank. I...
|
May 16th, 2009 12:23 PM
by TDay
|
1 |
225 |
|
|
#div/0! Error by
Karthik
Someone please let me know what's wrong with this formula.
=SUMPRODUCT(--(A$2:A$99=L$5),--(J$2:J$99=M$6),--(C$2:C$99=K30),--(H$2:H$99$L$2),H$2:H$99)
This...
|
|
3 |
268 |
|
|
How to Use Permissions by
Kev - Radio Man
Hi All,
I am trying to learn how to use Permissions?
I have followed the help file but I do not have "permissons" in the file
menu, and the button is...
|
|
0 |
229 |
|
|
No Templates by
Stephen
Using excel in office 2007 I am unable to save templates. The option within
the save as dialouge under the round top LH office button is simply not
there, it...
|
|
1 |
251 |
|
|
worksheet cross reference by
KUDOS
I use a excel workbook for quotes. A new worksheet for each quote. Worksheets
a numbered sequentially from 5000 onward.
I want to create a summary worksheet...
|
|
3 |
215 |
|
|
|
|
2 |
244 |
|
|
|
|
8 |
211 |