|
|
SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY by
Debra Dalgleish
There's an example here that counts visible cells in a filtered column.
You could modify the SUMPRODUCT formula to reference your cells, and add
one more...
|
January 11th, 2005 01:58 PM
by Lisa
|
3 |
146 |
|
|
templates by
Terri
I would like to create my own worksheet to save as a template for accountancy
book keeping for small business. I have searched for suitable templates...
|
January 11th, 2005 02:23 PM
by Terri
|
0 |
82 |
|
|
Help! + and - and blank cells by
Helen Black
I am trying to do a worksheet for our drivers hours, I have totalled up their hours and deducted 48 hours max working week, I have then deducted 48 hours off...
|
|
0 |
91 |
|
|
conditional formatting conflict? by
Abi
I have a three column sheet. The first column pulls information from another
sheet. The the other two are going to be blank with underline where someone
will...
|
January 11th, 2005 04:41 PM
by Abi
|
2 |
409 |
|
|
|
January 11th, 2005 05:19 PM
by JulieD
|
1 |
208 |
|
|
table by
dow
I need help making a table in Excel 2000. I want to make a table in a
worksheet (sheet 2) that incorporates numbers (calculation 1 & caculation 2)
that are...
|
January 11th, 2005 06:17 PM
by dow
|
0 |
119 |
|
|
Dates by
aeroman55
How can I return a date, six months plus the first of the following month
from a specified date? In other words, both January 1, 2005 and January 31,
2005...
|
|
2 |
105 |
|
|
Drop Down List by
Sandy
ello
Book1 a1 has a drop down list. Book2 c3 = Book1a1. I would like to create a
drop down for C3 that includes the same drop down from book1 but not...
|
January 11th, 2005 11:50 PM
by Max
|
3 |
336 |
|
|
|
|
2 |
315 |
|
|
Cell lock help by
S.C
Is there a way to lock a specific set of cells and not the whole work sheet?
I have several cells that have formulas in them that I do not want changed,
but...
|
|
2 |
90 |
|
|
Lookup by
tjh
Hello,
Is there a way to use a lookup function to another Excel File. I use
Vlookups and Hlookups in a single workbook, often. Is there a similar
function...
|
|
3 |
72 |
|
|
Updating links by
Brian
Help!
I have placed a two workbooks on a server one workbook relies on the other
for data. I have changed the sources after placing them on the server and...
|
|
1 |
85 |
|
|
refresh pivot tables through a macro by
dolph
Hi all,
I'm trying to create a macro to update pivot tables with a macro. but
when I create it and then try to run it, I receive the message: It'
impossible...
|
|
1 |
241 |
|
|
|
January 12th, 2005 04:37 AM
by Keith
|
3 |
95 |
|
|
Sumif, 2 criteria by
Steve
I have seen about a dozen entries with that subject. I can't get a single
of oneof them to work. Am I missing something? In the range n12:n1000 I am
looking...
|
|
5 |
105 |
|
|
|
|
0 |
350 |
|
|
|
|
1 |
197 |
|
|
|
January 12th, 2005 12:45 PM
by kevin
|
6 |
95 |
|
|
|
January 12th, 2005 02:06 PM
by RagDyeR
|
1 |
147 |
|
|
Calculation within IF function by
Andrew
I searched b-boards for previous comments, but I didn't see any.
The calculator on my desk says that 5625*0.07 =...
|
January 12th, 2005 02:37 PM
by Andrew
|
2 |
96 |