Microsoft Excel Worksheet Functions

C
How to auto sum cells if letters are in cells?
  • christinelday
Replies
2
Views
42K
Shane Devenshire
S
K
convert day of year to numeric value format year+day in 4 digits
  • Kaaren
Replies
3
Views
465K
Shane Devenshire
S
S
Can i make text in cells c60@n60 bold & black if sum of C59 is gre
  • Spartan C10
Replies
7
Views
21K
Fred Smith
F
G
Locking cells
  • Graham
Replies
3
Views
339K
Gord Dibben
G
M
count with multiple critirea
  • MANYHEADACHES
Replies
4
Views
363K
Shane Devenshire
S
H
Countif(and
  • Help with Countif(and
Replies
7
Views
306K
T. Valko
T
T
Excel 2007 vs 2003 menus.
  • Ted Stilwell
Replies
2
Views
13K
Shane Devenshire
S
C
How do I place a picture instead of words in a hidden comment box
  • Christy81267
Replies
2
Views
159K
xlmate
X
W
userform date issue
  • Woodi2
Replies
4
Views
232K
Woodi2
W
M
The If function
  • Matt
Replies
4
Views
390K
Pete_UK
P
D
Using SUMPRODUCT, 3 variables, 2 types of data in 1 column
  • Dana M
Replies
3
Views
382K
Pete_UK
P
G
conditional formating - dragging a cond. format over an entire col
  • Guest
Replies
3
Views
323K
Artem
A
L
how do i get a cell to fill red/blue as the outcome of a formula?
  • Lynz1976
Replies
13
Views
856K
Lynz1976
L
R
Referenced cell change when row is blank
  • Read
Replies
1
Views
343K
muddan madhu
M
N
Error message
  • Noepie
Replies
7
Views
260K
Noepie
N
A
Formula - assign a cell to show the next
  • ash3154
Replies
6
Views
529K
ash3154
A
S
SUMIF FUNCTION works in all cells but those related to one account
  • Skyhawk
Replies
4
Views
630K
T. Valko
T
R
Count Unique Numbers if Names Match
  • ryguy7272
Replies
4
Views
492K
Ashish Mathur
A
K
SUMIF function
  • Kathryn
Replies
7
Views
647K
Elkar
E
K
Question on which function to use
  • kurchian
Replies
2
Views
361K
Ashish Mathur
A
D
aging category calculation for open purchase order report in Excel
  • Dan gibbs
Replies
3
Views
351K
Ashish Mathur
A
N
DIV/0 error
  • Nicky
Replies
5
Views
447K
Ashish Mathur
A
C
Formula Help
  • Curtis
Replies
1
Views
239K
Paul
P
M
Compare and then copy cell to separate worksheet
  • Matt
Replies
1
Views
168K
Pete_UK
P
T
Double (triple?) Index Lookup
  • thedr9wningman
Replies
6
Views
332K
Max
M
I
Using lookup functions with conditions and constantly changing dat
  • (-) Ions
Replies
10
Views
668K
Max
M
K
finding multiple code dates for multiple item number
  • kmc
Replies
2
Views
288K
Glenn
G
T
How do I use countif like sumif ie (range,criteria,count_range)
  • tmarie
Replies
1
Views
326K
T. Valko
T
A
sum function
  • angie
Replies
3
Views
140K
Marcelo
M
C
VB Code
  • chrisnsmith
Replies
6
Views
639K
Don Guillett
D
T
dividng numbers using the sumif function
  • tiare1021
Replies
2
Views
194K
Mike H
M
C
My current formulas in documents have quit working
  • Clark
Replies
1
Views
91K
Mike H
M
P
Option Buttons, Forms Control, Excel 2007 - 3 options
  • Paula
Replies
6
Views
251K
Paula
P
W
Getting rid of VLOOKUP N/A
  • WA
Replies
3
Views
170K
WA
W
E
Function to find truncated entries?
  • EllenM
Replies
3
Views
415K
EllenM
E
Y
calculated celles according to more then 1 condition
  • -yuval
Replies
5
Views
311K
xlmate
X
J
"go to" "blanks" after using a formula
  • jhnnyboy247
Replies
2
Views
178K
T. Valko
T
M
Fill down without formatting macro
  • Mike
Replies
7
Views
451K
Bernie Deitrick
B
R
getting excel to recognise copied data as mm:ss not hh:mm
  • Ravi B
Replies
2
Views
225K
Shane Devenshire
S
S
Date functions and #value!
  • SafetyIntern
Replies
3
Views
212K
SelfTaughExcelJunkie
S
M
EXcel problem
  • MicrosoftBob
Replies
2
Views
188K
Shane Devenshire
S
S
how do i compare two text columns
  • sflanegin
Replies
1
Views
14K
Shane Devenshire
S
N
Pivot Table Chart Drop Down Box
  • Newbie
Replies
6
Views
549K
Newbie
N
D
Calculating ratios: Is there a formula that can do this?
  • dshadrock
Replies
2
Views
332K
Shane Devenshire
S
M
Find and replace dilemma
  • mismose
Replies
3
Views
13K
mismose
M
P
Formula please
  • Peta
Replies
6
Views
519K
Roger Govier
R
L
newbie
  • lena
Replies
5
Views
154K
joeu2004
J
G
vlookup for same name, multiple instances...
  • Guest
Replies
18
Views
501K
Pete_UK
P
M
Conditionl format for 3 cells Skipping the center cell
  • Mark
Replies
3
Views
353K
Pete_UK
P
J
Copy non merged to merged cells
  • jamalhakem
Replies
2
Views
220K
Pete_UK
P
You must log in or register to post here.
Back
Top