|
|
#NAME? by
77Debbie77
I am pulling my hair out!!! I have over 60,000 rows of data with comments and
am trying to add a function to a cell: =SUMPRODUCT(--('Closed calls as of...
|
|
5 |
131 |
|
|
|
|
3 |
136 |
|
|
|
|
2 |
94 |
|
|
follow up to nested subtotal/sumproduct by
SteveDB1
Hi again.
Yestyerday I was talking to Peo Sjoblom about a nested sumproduct with a
subtotal.
We did get it to work, but after I posted it was solved, I'd done...
|
|
0 |
71 |
|
|
If formula with two conditions to meet by
Carolina
I have the following scenario:
If the value in cell Z5 is equal or greater than "0" the person gets $700
AND
if in addition field value in cell AB5 reflects a...
|
|
7 |
81 |
|
|
"move tab sheets" by
Avinono1
is there a way to mpve the tab sheets from the bottom of the worksheet to the
side?
|
August 28th, 2008 05:12 PM
by Pete_UK
|
1 |
121 |
|
|
Cumulative labor calculation by
MarkMcG
Please forgive my indolence (and perhaps slothfullness). Communal work is
the best.
I have a salary for 2008. I want to calculate a 3.5% increase, year...
|
August 28th, 2008 05:02 PM
by MarkMcG
|
0 |
176 |
|
|
|
|
5 |
163 |
|
|
Complex SUMPRODUCT/VLOOKUP/SUMIF by
tigger
Hi there, hope someone can help.
I have a summary table within a spreadsheet where I am tracking actual and
forecast spend against individual projects.
I...
|
August 28th, 2008 04:30 PM
by tigger
|
1 |
79 |
|
|
|
August 28th, 2008 04:29 PM
by Spiky
|
2 |
116 |
|
|
|
|
1 |
129 |
|
|
Calculation of an UDF by
Werner Rohrmoser
Hello,
I've made an UDF to determine, whether a cell has a formula or not,
see listing...
|
|
5 |
99 |
|
|
|
|
1 |
114 |
|
|
NEED INFO to the left of rqd cell by
CAPTGNVR[_2_]
DEAR ALL
Can you pls give me how to write the INDEX AND MATCH function so that I can
get the left value in col-D interpolated for a col-D value say...
|
|
7 |
98 |
|
|
match with isna formula question by
Belinda7237
I want to bridge info from one workbook to a new workbook with a formula in
column V. but i have two criteria instead of one to consider the match before...
|
|
2 |
131 |
|
|
add If to formula to blank #n/a by
Diddy
Hi everyone,
I'm using the following formula
=INDEX(Stats!$K$2:$K$47,MATCH($B3,Stats!$G$2:$G$47,0))
How do I add to this to not have #N/A when it doesn't...
|
August 28th, 2008 11:16 AM
by Max
|
3 |
115 |
|
|
|
August 28th, 2008 08:06 AM
by MS
|
2 |
98 |
|
|
|
|
2 |
91 |
|
|
Active Cell Color by
Taurien
Hi!
Any function by which we can have active cell as colored or defferent from
other cells as usually we have to look at the row and column on top as its...
|
August 28th, 2008 07:53 AM
by Taurien
|
5 |
423 |
|
|
Simple IF , maybe, for names in columns by
Steve
I have a column of 40 names (A3:A43)
In column B, I have only 10 of those names
I'd like column C to show what names are not listed in column B ( the other
30...
|
August 28th, 2008 06:51 AM
by Max
|
7 |
125 |