Microsoft Excel Worksheet Functions

J
SUMIFS and dates
  • JLR-Mart
Replies
3
Views
247K
Fred Smith
F
R
Advanced Criteria for SUMIF
  • Roberto Villa Real
Replies
4
Views
180K
Hambo_NZ
H
M
Slicing Data (Alternative to SUMIFS)
  • Marcelo
Replies
2
Views
430K
Ashish Mathur
A
C
Method for creating formulas to reference different worksheets?
  • copticdred
Replies
3
Views
33K
Gord Dibben
G
S
Sumproduct Question
  • ShagNasty
Replies
1
Views
329K
Sheeloo
S
C
Formula Help
  • CHerzog
Replies
1
Views
171K
T. Valko
T
L
index and match, then subtract, divide and add for my final answer
  • ladygr
Replies
3
Views
363K
ladygr
L
B
sum cells with both alpha and values but...
  • bluthjen
Replies
0
Views
257K
bluthjen
B
T
Alternative to using 10 V-lookup formulas
  • Tami
Replies
2
Views
139K
T. Valko
T
M
How do I recalculate cell only if reference cell value changes?
  • murph
Replies
4
Views
180K
murph
M
O
Copying a cell ref. down a column, changing worksheet # along the
  • olivia
Replies
5
Views
503K
2traksDavid
2
T
Text into Columns
  • tcmh
Replies
3
Views
331K
Dave Peterson
D
D
combining data from multiple workbooks
  • dslocum
Replies
5
Views
246K
Dave Peterson
D
C
"IF" function returns function instead of result
  • ckrogers
Replies
6
Views
406K
Jarek Kujawa
J
C
IF function returns function statement rather than result
  • ckrogers
Replies
3
Views
126K
ckrogers
C
C
Can't save Excel spreadsheets
  • Claire
Replies
1
Views
156K
Kassie
K
G
Help with VLOOKUP & MATCH formula
  • GoBucks
Replies
5
Views
444K
GoBucks
G
R
EXCEL PASTE DOES NOT CHANGE DATA - PASTE DOESN'T WORK!
  • robin l
Replies
4
Views
117K
Susan
S
C
Percentage over a date range
  • CP
Replies
3
Views
298K
Eduardo
E
R
CANT INSERT CELLS, ONLY ROWS & COLUMNS
  • robin l
Replies
1
Views
39K
Jacob Skaria
J
B
Is there a Conditional Sum Wizard in Office 07? If so Where
  • Brian86
Replies
2
Views
93K
T. Valko
T
T
data in 2nd column associated with =MAX(H1:H100) from another colu
  • tcek
Replies
2
Views
96K
Mike H
M
A
Highlighting the entire row with conditional formatting
  • Allen
Replies
10
Views
1M
T. Valko
T
T
data associated with latest date
  • tcek
Replies
5
Views
225K
tcek
T
C
How to count/tally entries?
  • chrisk
Replies
1
Views
208K
chrisk
C
P
Text to rows
  • Phippsy
Replies
6
Views
517K
Phippsy
P
W
Lookup Function
  • Wasdell
Replies
2
Views
140K
klswvu
K
P
how to move contents in column up one cell
  • pmt
Replies
2
Views
69K
klswvu
K
S
Today() function
  • Steve
Replies
2
Views
119K
Luke M
L
P
Flatten password file
  • PSM
Replies
3
Views
547K
Tom Hutchins
T
S
Text to Number
  • Steve
Replies
3
Views
267K
Luke M
L
R
Calculate the number of hours in a date/time cell
  • richardwo
Replies
1
Views
166K
Jacob Skaria
J
S
Time/priority problem
  • sonic-the-mouse
Replies
2
Views
286K
Jacob Skaria
J
J
how do I use a cell from one worksheet in the equation of another
  • jpw
Replies
3
Views
270K
mclwlg
M
M
Stuck on Formulas
  • megsmom85
Replies
1
Views
168K
JudithJubilee
J
L
Numbers of repeats of a string
  • Luciano Paulino da Silva
Replies
11
Views
575K
macropod
M
A
Taking Average ignoring #DIV/0! in the range...
  • Astro
Replies
1
Views
189K
T. Valko
T
W
EDATE Function disappears intermittently
  • Wendy
Replies
1
Views
224K
T. Valko
T
Z
Pivot Table - Old remaining values for rows
  • ZorionK
Replies
3
Views
224K
ZorionK
Z
J
solver an uxexpected internal error ocurred, or available memory
  • Jorge A.
Replies
1
Views
232K
Jacob Skaria
J
P
Quarters
  • PAL
Replies
1
Views
176K
Jacob Skaria
J
T
filtering or selecting data baseed on time of day
  • TBA
Replies
1
Views
19K
Jacob Skaria
J
K
displaying changes
  • Kackels
Replies
1
Views
64K
Tom Hutchins
T
S
Help Calculating Partial Months between 2 dates.
  • sirscottyog
Replies
2
Views
169K
Ashish Mathur
A
B
SUMIF formula with non contiguous cells
  • Billy B
Replies
2
Views
385K
Ashish Mathur
A
J
Importing Data Wizard
  • John L
Replies
6
Views
159K
John L
J
V
Multiple results of Unique Values
  • VickiMc
Replies
3
Views
129K
Ashish Mathur
A
D
Deleting rows or columns
  • Darrell
Replies
1
Views
95K
Alan
A
B
How does one use a formula to bring over the formatting as well
  • Bud
Replies
1
Views
122K
Alan
A
M
Calculate Interest Rate
  • Mark Parent
Replies
2
Views
323K
JoeU2004
J
You must log in or register to post here.
Back
Top