|
|
Lookup by
Kaisa
A B C E F
1 SKU SUM SKU SUM
2 85 10 85 10
3 86 20 86 20
4 87 30 88 30
5 89 40
I'm trying to make a formula that can tell me the sum of each number....
|
|
3 |
197 |
|
|
|
|
1 |
210 |
|
|
GETPIVOTDATA and (blank) by
Tige Brown
I have created a spreadsheet which has two pivot tables in it on separate
sheets. In addition there is a summary sheet which I use the GETPIVOTDATA
function...
|
|
0 |
204 |
|
|
|
|
2 |
225 |
|
|
IF and Right Functions by
Elaine
Hello,
I have part #'s that end in 3 or 4 characters, some with a space. I would
like to display the last 3 or 4 characters in another column. I tried using...
|
April 23rd, 2010 12:34 AM
by Elaine
|
9 |
384 |
|
|
why this strange result with vlookup by
Amin
hi i have this formula in a cell =VLOOKUP(A3,'LookUp Data'!A2:O740,2,FALSE)
but any time i pick a code from my list items in column A it gives #NA but
as soon...
|
April 23rd, 2010 12:16 AM
by Max
|
3 |
333 |
|
|
Copying Cells with Fill Handle by
RRG
Can anyone help? I am trying to copy cells across a row using the fill handle
that are referencing another sheet down a column. I am placing a "$" in front...
|
|
3 |
238 |
|
|
Categorizing Data Question by
Demosthenes
Hello,
I have a list of data in C, and would like to create a column in D that
organizes that data into a specific category. For example, given:
Fruit ...
|
April 22nd, 2010 11:48 PM
by Pete_UK
|
4 |
237 |
|
|
|
April 22nd, 2010 11:08 PM
by CLR
|
1 |
308 |
|
|
Conditional Formatting in Excel 2007 by
kvollmer
I have probably 30 conditional formats built in one file, but when I "saved
as" to another name to create another file, only a few of the conditional
formats...
|
|
1 |
245 |
|
|
"#VALUE!" Cell Value by
DisMusBeDaPlaz
Some of my cells are turning up the value "#VALUE!" in the cells.
I have duplicated the problem that I am having. A test worksheet.
I am using data in one...
|
|
1 |
233 |
|
|
How do I use sumifs - by
wantfit
I want to use sumifs to find the results. For range A1:A100, If value in
column A = column C (a1=c1, or a2=c2,etc), then sum up Range A1:A100. How do
I do...
|
|
1 |
224 |
|
|
Counting by color by
Danny Boy
I saw this formula on Chip Pearson's site. According to Chip:
You can use the ColorIndexOfRange function to get the sum of the values in
those cells whose...
|
|
3 |
266 |
|
|
Grouping on protected worksheets by
wnwilkerson
I want to protect the cells in my worksheet, but when I do I am no longer
able to collapse or expand grouped items (rows/columns). Any ideas on how to...
|
|
4 |
243 |
|
|
|
|
3 |
448 |
|
|
xlbgnm in remote data by
Bill Johnson
I have an xls (2003) excel spread sheet that calls data from another
application (DDE) like this:
=RSLINX|'PC2'!'ANA' and like this =Rslinx|'EC2'!ACT01
This...
|
|
1 |
637 |
|
|
Conditional Formula Words by
Fab
Okay here we go.
I need to create a Conditional Formula that
1. Identifies the words i.e. Single Adult or Single Adult + 1 Child and then
returns the number...
|
April 22nd, 2010 07:57 PM
by JLatham
|
4 |
234 |
|
|
|
April 22nd, 2010 07:38 PM
by Olivia
|
2 |
235 |
|
|
multiple IF calculations by
mel
I've figured out how to make cell X display the number of hours entered into
D9 if the text "Stat Worked" appears in D11, but now I need to do the same
for...
|
April 22nd, 2010 07:18 PM
by mel
|
6 |
195 |
|
|
Default Cell value in changing environment by
TheDrescher
I don't know if this is possible to do, but I figured I'd ask. I have a
workbook where the first worksheet populates data on employees based on their
name...
|
|
3 |
223 |