Microsoft Excel Worksheet Functions

E
sum across 12 worksheets
  • EricSHEM
Replies
3
Views
303K
T. Valko
T
J
How do I convert a column of positive numbers to negitive numbers
  • JMason
Replies
1
Views
269K
Pete_UK
P
R
Conditional format with error & date check
  • RobofMN
Replies
3
Views
70K
T. Valko
T
D
Excel Formulas
  • djs
Replies
5
Views
434K
Pete_UK
P
J
vlookup not working
  • Juan
Replies
3
Views
406K
Gord Dibben
G
M
Advanced Filter - Exclude two criteria in separate columns
  • Mark
Replies
2
Views
437K
bapeltzer
B
M
CUMIPMT function error
  • MichaelJ
Replies
1
Views
90K
Ron Rosenfeld
R
T
Referencing closed file
  • TheErick
Replies
6
Views
145K
Dave Peterson
D
M
insert sumif, shows value of 1709, but displays value 0
  • Macil
Replies
1
Views
63K
Joel
J
J
LEFT function-all to left of a comma?
  • Jennifer F
Replies
1
Views
83K
Joel
J
A
line graph showing monthly trend
  • AJ
Replies
1
Views
125K
AJ
A
Y
sumif of non-adjacent cells
  • YHP
Replies
1
Views
275K
T. Valko
T
C
displaying running total of value entered in same cell?
  • Colin Fisher
Replies
6
Views
256K
Gord Dibben
G
S
Matrix Type Lookup
  • Search & You Will Find
Replies
4
Views
335K
T. Valko
T
B
hide row when adjacent column has zero(0)
  • beesleyh
Replies
1
Views
188K
Bob Alhat
B
M
Concatenate an Hyphen
  • Michael
Replies
3
Views
290K
Michael
M
P
COUNTIF help
  • plaw
Replies
2
Views
25K
Gary''s Student
G
E
IF Formula problem
  • Erika Renicker
Replies
1
Views
213K
Luke M
L
M
I need a formula to add numbers to the result in same cell.
  • marciahays
Replies
1
Views
246K
Luke M
L
M
finding n-th most frequently occuring word
  • Matt Stayton
Replies
4
Views
314K
Matt Stayton
M
E
Concatenating 3 text columns into a useable date
  • EMREMEV
Replies
1
Views
18K
T. Valko
T
S
Dynamically Named Range and IsError()
  • Stephen Lloyd
Replies
5
Views
529K
T. Valko
T
N
Show 2 different work sheets side by side
  • Need help
Replies
1
Views
204K
Gord Dibben
G
N
freeze
  • nader
Replies
1
Views
133K
Gord Dibben
G
E
Step Calculation
  • Eric
Replies
7
Views
701K
Roger Govier
R
P
ADD (not insert) worksheets into an already exiting document
  • Phyllis
Replies
6
Views
286K
Gord Dibben
G
J
Merged cells
  • jamalhakem
Replies
1
Views
89K
Joel
J
S
Countif for dddd format
  • smcmoran
Replies
4
Views
649K
smcmoran
S
F
Lookup a name if cell value first letter is in a range
  • FirstVette52
Replies
1
Views
313K
Pete_UK
P
M
Match & IF
  • Martinc126
Replies
1
Views
167K
Glenn
G
C
how can I insert a blank row after each subtotal in a worksheet
  • chappy
Replies
9
Views
392K
chappy
C
T
total columns of one sheet on another sheet
  • Tash
Replies
1
Views
261K
Pete_UK
P
S
Exporting tasks
  • se7098
Replies
2
Views
87K
se7098
S
R
how do i link data from closed worksheets without vlookup.
  • Rainmaker
Replies
1
Views
181K
Bernie Deitrick
B
J
Changing values by a %
  • jon
Replies
4
Views
83K
Pete_UK
P
W
COUNTIF function query
  • Wendy-Bob
Replies
6
Views
323K
Billy Liddel
B
G
Cell Should always be the most recent Saturday
  • Gringarlow
Replies
2
Views
409K
mikebres
M
J
I accidentally saved over important data and cannot retreive it
  • Jenny_Coppiano
Replies
2
Views
15K
jon
J
C
Vlookup?
  • collyer3
Replies
3
Views
170K
Max
M
J
Grouping columns - error message
  • JRT
Replies
2
Views
196K
JRT
J
P
Linking pictures to spreadsheet
  • philcud
Replies
1
Views
45K
philcud
P
A
countifs on earlier version of excel
  • Aaron Hodson \(Coversure\)
Replies
5
Views
232K
Aaron Hodson \(Coversure\)
A
A
SUMPRODUCT in earlier verions
  • Aaron Hodson \(Coversure\)
Replies
5
Views
323K
Aaron Hodson \(Coversure\)
A
D
Freeze Multiple Rows
  • Desk_Jockey_03
Replies
2
Views
171K
Ron@Buy
R
H
Link to an empty cell question.
  • h2fcell
Replies
2
Views
247K
Ron@Buy
R
A
I want format cells to have expiry dates & highlight
  • Aims
Replies
1
Views
201K
Max
M
S
How can I display symbols in phone # formatted cell when empty?
  • Sandi Rutalnd
Replies
1
Views
261K
Harlan Grove
H
D
formula remian in cell
  • Dylan @ UAFC
Replies
2
Views
13K
Gord Dibben
G
G
lookup functions and text comparisons
  • GK
Replies
1
Views
162K
Max
M
T
Financial Year Month Number
  • Tiffany
Replies
3
Views
176K
Ron Rosenfeld
R
You must log in or register to post here.
Back
Top