Microsoft Excel Worksheet Functions

M
sum results based on a reference
  • Mauro
Replies
4
Views
232K
Otto Moehrbach
O
G
Problem with Yield() function
  • Greg Lovern
Replies
5
Views
898K
rahul k
R
B
would like to combine info. fr different location on a list
  • Bklynhyc
Replies
3
Views
245K
Don Guillett
D
B
how to vlookup colume with different values
  • Bklynhyc
Replies
2
Views
160K
Bklynhyc
B
M
Function Syntax not showing - xnpv
  • Mike
Replies
1
Views
156K
T. Valko
T
V
If, then statement with the condition a blank cell
  • vew
Replies
10
Views
483K
David Biddulph
D
M
Sum for 26 worksheets on one workbook
  • MO
Replies
10
Views
157K
MO
M
J
How do I write an array to include all worksheets in a workbook?
  • Jodie
Replies
8
Views
225K
Bernard Liengme
B
D
£#,###,"k" format tweak
  • David
Replies
2
Views
53K
David
D
N
IF column B = anything in column A format
  • Nelson
Replies
1
Views
241K
Max
M
M
Compare data (2 columns) from 2 worksheets within a workbook
  • MO
Replies
2
Views
233K
MO
M
J
Link to another workbook
  • John
Replies
2
Views
234K
Glenn
G
M
SUMPRODUCT and "--"
  • Michelle
2
Replies
37
Views
92K
rock star
R
B
% commision
  • Bogi
Replies
1
Views
20K
Jacob Skaria
J
M
sumif & sumproduct
  • MichelleT
Replies
7
Views
347K
Bernd P
B
R
Remove the char from right
  • Ranjith Kurian
Replies
2
Views
219K
Ranjith Kurian
R
S
Counting coloured cells
  • SNC-DW
Replies
3
Views
312K
SNC-DW
S
W
cell reference
  • Woodi2
Replies
3
Views
287K
David Biddulph
D
T
Matching two list - How can I do it?
  • TC
Replies
1
Views
19K
Ms-Exl-Learner
M
P
Conditional Arrays
  • Paul66
Replies
1
Views
206K
Max
M
D
confirm the missing numbers in a series
  • driller2
Replies
5
Views
287K
driller2
D
K
VLOOKUP & 2 arguments
  • kimha
Replies
8
Views
67K
Ashish Mathur
A
R
IF AND OR problem.
  • Romileyrunner1
Replies
12
Views
730K
Romileyrunner1
R
V
Is it possible to add rows to a range using input form
  • Vanya
Replies
1
Views
151K
Jacob Skaria
J
B
Counting Zeros in a row until encounter first non-zero value
  • Bubba
Replies
9
Views
1M
Ashish Mathur
A
K
First Half / Second Half Month Budget
  • Kerri
Replies
3
Views
311K
Ashish Mathur
A
J
Sorting by last digits in cell
  • Julie
Replies
4
Views
357K
Ashish Mathur
A
D
Formatting time in Excel 2007
  • Debbi
Replies
3
Views
170K
Ashish Mathur
A
S
How to Merge Two Cells IF Another Cell Matches
  • suzikeith
Replies
2
Views
192K
Jacob Skaria
J
P
i need a formula for two columns to sum and to be able divide the
  • Pat
Replies
4
Views
71K
Jacob Skaria
J
D
Vlookup problem
  • Debbie
Replies
5
Views
579K
Debbie
D
M
Unprotected cells
  • Mainer
Replies
2
Views
41K
Jacob Skaria
J
P
2 colums needs to sum and the anwsers needs to divide to get a pe
  • Pat
Replies
3
Views
118K
Pat
P
R
How to display the values of multiple cells in a text string?
  • Robert R
Replies
1
Views
196K
Fred Smith
F
R
Creating Summary Worksheet
  • RobFJ
Replies
2
Views
131K
ryguy7272
R
G
Excel - Summing common cell over mutiple sheets within a file?
  • Guest
Replies
5
Views
180K
cmh52404
C
T
How to sum one cell across workbook if nr of worksheets is variabl
  • Tezza
Replies
2
Views
282K
ryguy7272
R
C
Check boxes and text strikethrough / color change
  • Christine
Replies
2
Views
49K
ryguy7272
R
T
Conditional Format question
  • tbernhardt
Replies
1
Views
122K
Ken
K
S
Why is VLOOKUP returning a value from the row above?
  • Summerfun
Replies
7
Views
445K
Summerfun
S
P
Formula to round off number to .95 cents
  • Pat
Replies
3
Views
563K
Pat
P
F
Trying to SUM variable number of VLOOKUPs
  • Friday
Replies
7
Views
711K
Jacob Skaria
J
M
FILTERING RESULTS
  • MIKEZ
Replies
5
Views
27K
Atishoo
A
L
Mod Function
  • Lizz45ie
Replies
4
Views
332K
Glenn
G
V
Vertical Database to Horizontal?
  • Valerie
Replies
4
Views
405K
Otto Moehrbach
O
M
Count cell except those contain zero
  • Manos
Replies
4
Views
162K
David Biddulph
D
C
Sum Postitive Values
  • crysallisa
Replies
5
Views
336K
T. Valko
T
T
countifs
  • Trev
2
Replies
23
Views
798K
Jacob Skaria
J
D
How do I add cell values that are in different rows/columns?
  • divadiva
Replies
1
Views
153K
Fred Smith
F
J
Multifunctional formula
  • John T
Replies
2
Views
48K
Jacob Skaria
J
You must log in or register to post here.
Back
Top