Microsoft Excel Worksheet Functions

P
Sumproduct gives #VALUE
  • Phil_S
Replies
3
Views
200K
Don Guillett
D
A
in ms excel how to count the no of cells
  • anji
Replies
3
Views
112K
Dana DeLouis
D
K
Summing values, x rows deep, depending on a criterion
  • klm
Replies
2
Views
257K
klm
K
M
password protect certain cells change
  • Miree
Replies
1
Views
79K
Otto Moehrbach
O
S
Login Name and now function
  • saran
Replies
3
Views
82K
saran
S
C
Database price updating
  • chefdoug
Replies
3
Views
442K
Max
M
R
Counting number of cells that match name AND number
  • Ronster
Replies
4
Views
403K
Mike H
M
A
How do I use the excel function "funformula"?
  • Ade
Replies
1
Views
47K
Héctor Miguel
H
E
Macro Button or Auto Protect Formula
  • enna49
Replies
3
Views
63K
enna49
E
S
ColorIndexOfOneCell
  • shank
Replies
8
Views
383K
shank
S
S
help with formula
  • so confused
Replies
3
Views
233K
Mike H
M
A
Average for times using minutes and seconds
  • aj81a
Replies
2
Views
279K
Sasa Stankovic
S
S
How to copy cells from one worksheet to another if the value in ra
  • sgtpsychosis
Replies
4
Views
410K
Otto Moehrbach
O
L
Word size for each cell
  • Lookup formula limitation?
Replies
1
Views
27K
Sasa Stankovic
S
N
Multiple question requiring asistance please
  • NoodNutt
Replies
2
Views
145K
JLatham
J
V
Advanced Filter how to include columns
  • V
Replies
1
Views
196K
Debra Dalgleish
D
B
Count occurrents based on criteria in different column
  • Blueagm
Replies
1
Views
159K
T. Valko
T
M
Conditional formatting & decimal part of a number in cell
  • Mac
Replies
2
Views
296K
Mac
M
R
tabs are missing even though 'tools-options-view-sheet tabs' ok?
  • rgranell
Replies
3
Views
310K
Gord Dibben
G
M
Summarising Data
  • Murray
Replies
5
Views
224K
Mike H
M
E
Sort Worksheets (without VB)
  • Elgee
Replies
4
Views
162K
Don Guillett
D
A
change data of entire column from small case to upper case
  • Ann
Replies
1
Views
92K
Dave Peterson
D
D
Take a 3 or for digit time and convet it to time in one cell
  • Djbaker70
Replies
8
Views
136K
Héctor Miguel
H
M
Sort by color: Is there an easy way to sort columns or rows in EX
  • MGP
Replies
5
Views
187K
Bob Phillips
B
J
countif on cells with formula's won't work correctly
  • JusMe
2
Replies
21
Views
1M
JusMe
J
D
Converting Millitary Time to Hours worked and OT hours
  • Djbaker70
Replies
3
Views
101K
Peo Sjoblom
P
D
Making a cell change time to hours
  • Djbaker70
Replies
2
Views
213K
Héctor Miguel
H
K
Use the custom filter dialog in a macro
  • KenInPortland
Replies
3
Views
339K
Héctor Miguel
H
M
Visual Basic Erro 400
  • Minitman
Replies
2
Views
133K
Minitman
M
T
How to schedule an auto "Save As" of an Excel spreadsheet daily...
  • Turbine Mechanic
Replies
2
Views
322K
NoodNutt
N
J
Changing text colors for editing
  • Jalynno
Replies
1
Views
63K
Gord Dibben
G
L
COUNTIF a cell value is between two numbers
  • LAWNDALE
Replies
3
Views
128K
T. Valko
T
P
EXCEL CELL MERGE
  • Patricia
Replies
3
Views
313K
Patricia
P
G
SUMPRODUCT formula compare then count
  • Greg in CO
Replies
3
Views
305K
Greg in CO
G
T
Eliminating Values from a worksheet
  • Terry
Replies
4
Views
184K
pshepard
P
P
How to reference or redirect a formula in a base row?
  • Paul Schrum
Replies
3
Views
204K
pshepard
P
D
today functions
  • diggs
Replies
4
Views
86K
Gord Dibben
G
J
SEARCH and IF
  • Jorge
Replies
3
Views
57K
T. Valko
T
L
"COUNT IF BELONGS" formula?
  • lorenzo
Replies
10
Views
326K
Roger Govier
R
B
help with adding up hours and mins please
  • baz
Replies
3
Views
175K
T. Valko
T
A
Use of IF with arrays
  • Andrew L
Replies
5
Views
501K
T. Valko
T
J
Assigning times to shift
  • Jon M
Replies
5
Views
181K
Jon M
J
F
Data trapping
  • Flipper
Replies
5
Views
45K
Glenn
G
G
Data pick-up 02
  • Geoffric
Replies
3
Views
66K
Teethless mama
T
R
Using Vlookup where the Lookup Value also uses Vlookup
  • reddy
Replies
6
Views
675K
reddy
R
F
Is this weird or what?
  • Finance Guru
Replies
8
Views
256K
Jarek Kujawa
J
D
vlookup with offset?
  • d0711
Replies
5
Views
125K
Jarek Kujawa
J
F
More conditional formatting...
  • FIRE GIRL
Replies
2
Views
162K
FIRE GIRL
F
S
plus-minus buttons in far left column (1)
  • Steve
Replies
3
Views
298K
Steve
S
D
Automatic Date and Times
  • D. West
Replies
2
Views
58K
Gary Brown
G
You must log in or register to post here.
Back
Top