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
805
JHL
J
K
Absolute Cell References
  • Karen
Replies
2
Views
474
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
376
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
297
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
453
LefepeCalambau
L
T
not exact duplicates...
  • Tadder
Replies
3
Views
404
Bernard Liengme
B
J
Cross referencing two workbooks?
  • Jeffrey
Replies
3
Views
471
Gord Dibben
G
K
Paste into grouped sheets using VB
  • kara stevenson
Replies
2
Views
513
Dave Peterson
D
T
closing grouped columns
  • Terry
Replies
2
Views
355
Dave Peterson
D
T
Another SUMPRODUCT SUBTOTAL question...
  • Trevor Williams
Replies
7
Views
645
Mike H
M
G
Help with questionnaire responses
  • Gemz
Replies
3
Views
429
Trevor Williams
T
M
excel 2003 - formatting cells - colour
  • mikeey
Replies
1
Views
468
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
396
David Biddulph
D
C
Countif Help
  • Christopher Naveen
Replies
8
Views
545
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
532
Pete_UK
P
J
IF Function not working
  • Jomark
Replies
8
Views
531
Jomark
J
E
table
  • ellebelle
Replies
5
Views
352
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
442
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
613
John
J
J
Matching column criteria in a one to many relationship
  • JB Akron
Replies
8
Views
618
Max
M
L
Nested If statement or lookup?
  • Lee
Replies
1
Views
415
Max
M
D
How to stop index match returning data where lookup cell empty
  • Diddy
Replies
4
Views
589
Diddy
D
G
Min if Function?
  • gb_S49
Replies
4
Views
574
T. Valko
T
A
Format cell based on date
  • Arthur
Replies
1
Views
345
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
386
Ken
K
P
How days since last visited
  • Pablo
Replies
4
Views
575
T. Valko
T
B
How can I make a cell = another cell based on a condition?
  • breezy
Replies
13
Views
670
breezy
B
M
Using Add-in = Fourier Analysis
  • MichaelRobert
Replies
9
Views
675
Dana DeLouis
D
L
Rand() formula
  • Luke
Replies
14
Views
793
Luke
L
S
Match Q
  • Seanie
Replies
4
Views
362
Seanie
S
P
conditional count
  • Peter Do
Replies
6
Views
403
T. Valko
T
K
Conditional formatting - sort of
  • kafter244
Replies
4
Views
471
kafter244
K
R
If statement or lookup statement not sure
  • Renegade40
Replies
2
Views
490
Renegade40
R
L
Need formula
  • Lori
Replies
3
Views
372
T. Valko
T
L
Setting up functions and rules
  • Lori
Replies
18
Views
570
Ragdyer
R
M
Countif & AND functions
  • Mick
Replies
3
Views
355
Mick
M
M
How to get info from adjacent cells
  • MIK
Replies
3
Views
354
T. Valko
T
J
When using a rolling average, is this possible
  • JW118877
Replies
1
Views
420
Shane Devenshire
S
J
Selecting specific numbers from a cell containing multiple numbers
  • JRD
Replies
3
Views
606
Shane Devenshire
S
Back
Top