Microsoft Excel Worksheet Functions

Post thread
H
sumif returns blank if all cells blank
  • Heliocracy
Replies
7
Views
2K
Stu
S
J
Help with Sumif and INDIRECT
  • JHL
Replies
9
Views
840
JHL
J
K
Absolute Cell References
  • Karen
Replies
2
Views
490
Keith Faulconer
K
L
sumif formula to calculate value of cell if certain criteria are m
  • Lisa
Replies
5
Views
1K
Stu
S
G
Vlookup.
  • GEM
Replies
3
Views
243
GEM
G
B
Excel 2007
  • bobrwag
Replies
1
Views
324
Keith Faulconer
K
G
Adding Cells, Get Error.
  • GEM
Replies
2
Views
401
Keith Faulconer
K
D
conditional format ref., diff work sheet
  • djc
Replies
2
Views
506
Glenn
G
N
Formula based on multiple criteria
  • Newsgal
Replies
2
Views
298
Chip Pearson
C
G
Week Number.
  • GEM
Replies
3
Views
400
Bernard Liengme
B
L
Show in a Cell the Value for another Cell
  • LefepeCalambau
Replies
2
Views
467
LefepeCalambau
L
T
not exact duplicates...
  • Tadder
Replies
3
Views
428
Bernard Liengme
B
J
Cross referencing two workbooks?
  • Jeffrey
Replies
3
Views
475
Gord Dibben
G
K
Paste into grouped sheets using VB
  • kara stevenson
Replies
2
Views
534
Dave Peterson
D
T
closing grouped columns
  • Terry
Replies
2
Views
356
Dave Peterson
D
T
Another SUMPRODUCT SUBTOTAL question...
  • Trevor Williams
Replies
7
Views
661
Mike H
M
G
Help with questionnaire responses
  • Gemz
Replies
3
Views
438
Trevor Williams
T
M
excel 2003 - formatting cells - colour
  • mikeey
Replies
1
Views
470
Bernard Liengme
B
F
Testing a cell value
  • Finance Guru
Replies
4
Views
422
Finance Guru
F
J
CF looking at more than 1 cell
  • Jock
Replies
3
Views
405
David Biddulph
D
C
Countif Help
  • Christopher Naveen
Replies
8
Views
577
Max
M
S
count specific No. of dates
  • Shujjat Rasool
Replies
1
Views
307
Bob Phillips
B
D
Adding a criteria to sumproduct
  • Diddy
Replies
5
Views
551
Pete_UK
P
J
IF Function not working
  • Jomark
Replies
8
Views
552
Jomark
J
E
table
  • ellebelle
Replies
5
Views
360
ellebelle
E
H
Refresh formula links to closed Workbooks
  • h2fcell
Replies
1
Views
2K
Roger Govier
R
R
formual, match G19 from G2:g17 return corresponding A2:A17
  • ref at heart
Replies
6
Views
446
T. Valko
T
A
How do I get worksheets in name order within a workbbook?
  • Accoounting 2008 Pro
Replies
1
Views
295
Mike Rogers
M
W
Check Mark in a cell
  • Wally
Replies
1
Views
622
John
J
J
Matching column criteria in a one to many relationship
  • JB Akron
Replies
8
Views
635
Max
M
L
Nested If statement or lookup?
  • Lee
Replies
1
Views
467
Max
M
D
How to stop index match returning data where lookup cell empty
  • Diddy
Replies
4
Views
607
Diddy
D
G
Min if Function?
  • gb_S49
Replies
4
Views
606
T. Valko
T
A
Format cell based on date
  • Arthur
Replies
1
Views
352
Fred Smith
F
D
Locking combo box into a cell?
  • driscolp
Replies
1
Views
4K
Gord Dibben
G
K
Conditional Formatting
  • Ken
Replies
2
Views
399
Ken
K
P
How days since last visited
  • Pablo
Replies
4
Views
580
T. Valko
T
B
How can I make a cell = another cell based on a condition?
  • breezy
Replies
13
Views
712
breezy
B
M
Using Add-in = Fourier Analysis
  • MichaelRobert
Replies
9
Views
695
Dana DeLouis
D
L
Rand() formula
  • Luke
Replies
14
Views
814
Luke
L
S
Match Q
  • Seanie
Replies
4
Views
364
Seanie
S
P
conditional count
  • Peter Do
Replies
6
Views
420
T. Valko
T
K
Conditional formatting - sort of
  • kafter244
Replies
4
Views
672
kafter244
K
R
If statement or lookup statement not sure
  • Renegade40
Replies
2
Views
494
Renegade40
R
L
Need formula
  • Lori
Replies
3
Views
387
T. Valko
T
L
Setting up functions and rules
  • Lori
Replies
18
Views
592
Ragdyer
R
M
Countif & AND functions
  • Mick
Replies
3
Views
358
Mick
M
M
How to get info from adjacent cells
  • MIK
Replies
3
Views
362
T. Valko
T
J
When using a rolling average, is this possible
  • JW118877
Replies
1
Views
429
Shane Devenshire
S
J
Selecting specific numbers from a cell containing multiple numbers
  • JRD
Replies
3
Views
606
Shane Devenshire
S
Back
Top