Microsoft Excel Worksheet Functions

G
SumProduct or CountIf
  • Guest
Replies
7
Views
141K
KL
K
G
VLOOKUP and ISNA functions
  • Guest
Replies
2
Views
93K
Guest
G
G
Not filtering entire Database
  • Guest
Replies
2
Views
61K
Dave Peterson
D
G
Can I format to always AutoFilter specific cells
  • Guest
Replies
1
Views
48K
Dave Peterson
D
G
Maintaining Protection when copying
  • Guest
Replies
1
Views
63K
Dave Peterson
D
G
Establish a Branch of Clayton College here in Malaysia
  • Guest
Replies
2
Views
74K
Dave Peterson
D
G
How do I count occurences in a date range?
  • Guest
Replies
2
Views
86K
Dave Peterson
D
G
What Excel Formula = finding dup records and removing them?
  • Guest
Replies
1
Views
83K
Anne Troy
A
G
create list of unique values from a column with repeated values?
  • Guest
Replies
1
Views
130K
Anne Troy
A
G
Repositioning the tabs
  • Guest
Replies
1
Views
90K
Anne Troy
A
G
Excel
  • Guest
Replies
1
Views
42K
Niek Otten
N
C
Convert "800" to "8:00" or "08:00"
  • CPK
Replies
5
Views
319K
Flintstone
F
G
Extracting Text from the right
  • Guest
Replies
6
Views
83K
Guest
G
G
Comments Not Always Printing At End
  • Guest
Replies
1
Views
28K
Anne Troy
A
B
Quick Little Function Help...
  • Brian07002
Replies
2
Views
81K
Brian07002
B
G
What does 'cell("color",A1)' do?
  • Guest
Replies
2
Views
246K
Biff
B
G
using sumif formula: but requiring satisfying 2 if statements
  • Guest
Replies
1
Views
463K
Bernard Liengme
B
G
Headers on every worksheet
  • Guest
Replies
1
Views
97K
Anne Troy
A
G
Conditional Sum Wizard
  • Guest
Replies
1
Views
46K
Anne Troy
A
G
How to create summary of expense report?
  • Guest
Replies
2
Views
131K
Guest
G
G
sumproduct between two dates
  • Guest
Replies
4
Views
192K
Guest
G
J
A Challenge
  • Jazzer
Replies
3
Views
89K
Harlan Grove
H
R
=sumproduct((f5:f498=(cp5:cq5))*(e5:e498=(cp6:ct6) )*(m5:m498))
  • Ruthki
Replies
2
Views
78K
Ruthki
R
S
want blank - not #N/A
  • sunflower
Replies
3
Views
40K
sunflower
S
G
Sums according to the content of fields
  • Guest
Replies
3
Views
115K
Guest
G
G
Contents of adjacent cell from a function
  • Guest
Replies
5
Views
296K
RagDyeR
R
G
How do I copy formatting from 1 sheet to next in same workbook?
  • Guest
Replies
1
Views
182K
Guest
G
D
Running Total
  • D.J.Shaw
Replies
1
Views
63K
Guest
G
G
Discount calculation
  • Guest
Replies
2
Views
41K
Guest
G
G
Tab Color - Excel 97
  • Guest
Replies
4
Views
237K
Guest
G
M
Doing a grouped search in Excel.
  • mikkellund
Replies
1
Views
104K
Dave Peterson
D
G
Nested Funtions
  • Guest
Replies
7
Views
219K
Guest
G
D
Running total
  • D.J.Shaw
Replies
1
Views
34K
Gordon
G
D
count unique with conditions
  • \ditzman via OfficeKB.com\
Replies
8
Views
640K
slc
S
J
Remove Time Element of a Date
  • jennie
Replies
3
Views
90K
jennie
J
G
Why "datedif" function results sometimes negative numbers?
  • Guest
Replies
1
Views
85K
Ron Rosenfeld
R
G
Format to Thousands and x-foot the sum
  • Guest
Replies
1
Views
28K
Gordon
G
G
EXTRACT TEXT FROM TEXT STRING
  • Guest
Replies
4
Views
81K
Guest
G
G
cell hililte
  • Guest
Replies
2
Views
42K
Bob Phillips
B
G
How to calculate a person's age taking into account their birthda.
  • Guest
Replies
4
Views
185K
Guest
G
K
Data Validation
  • Ket
Replies
1
Views
121K
DM Unseen
D
G
How do I translate from 5Row/20Col to 20Row/5Col ?
  • Guest
Replies
5
Views
118K
Guest
G
G
how do I use a cell value as part of a cell refereren in a formula
  • Guest
Replies
2
Views
69K
Max
M
E
I need a Formula, Please
  • easybucks
Replies
2
Views
162K
agarwaldvk
A
G
Quick formula question
  • Guest
Replies
8
Views
24K
ScottO
S
G
Different quantities of a certain item...
  • Guest
Replies
1
Views
145K
agarwaldvk
A
G
Change General Format to Currency Format
  • Guest
Replies
3
Views
112K
Max
M
S
can it be done without vb
  • spikk
Replies
3
Views
26K
Tushar Mehta
T
G
How do I put each member of string concatenation in its own line?
  • Guest
Replies
3
Views
196K
ScottO
S
G
How do I make hide detail buttons in Excel 2002?
  • Guest
Replies
1
Views
53K
ScottO
S
You must log in or register to post here.
Back
Top