|
|
|
May 11th, 2010 03:40 AM
by GS
|
22 |
1,044 |
|
|
Count Blanks in a Filtered Column by
Gos-C
Hi,
Is there a function to count blanks in a filtered column? That is, if
I filter a column to show the rows that are blank, can I use the
subtotal function...
( 1 2 3)
|
|
21 |
540 |
|
|
|
|
21 |
355 |
|
|
Need help with Countif function by
Mary-Lou
I need to count two different text values within two columns.
Column A contains sentences and Column B contains various values.
Example of small sentences in...
( 1 2 3)
|
|
21 |
327 |
|
|
COUNTIF problem with NOW() by
Spreadsheet
=COUNTIF(ALL!AC2:AC1000,"NOW()-21")
This is the formula I'm using. I'm trying to determine how many dates
in column AC are more than three weeks ago. It's...
( 1 2 3)
|
June 26th, 2006 09:47 PM
by SteveG
|
21 |
466 |
|
|
SumIf query ... by
muchacho
Does this function ignore invisible cells (autofilter) ?
If not, what could be an...
( 1 2 3)
|
|
21 |
308 |
|
|
convert meters to feet/inches by
Ann
i'm trying to convert from meters to feet and inches (not just feet or not
just inches).
so if i have 2 meters, i want the result to read 6 feet, 2 inches for...
( 1 2 3)
|
|
21 |
306 |
|
|
Countdiff with more criteria by
JP Ronse
Hi All,
I would like to count a sort of diversity per person and per month.
Sample data:
Customer Engineer Date
A JP 01/11/2009
A Bill...
( 1 2 3)
|
December 22nd, 2009 01:07 AM
by T. Valko
|
21 |
300 |
|
|
date from sheet name by
JBoulton
I'd like to turn a sheet name into a date.
Apr28 to 4/28/10 (as a date)
and
Apr28-30 to Apr28-30 (as text)
TIA and thanks for any ideas.
Jim
( 1 2 3)
|
|
21 |
353 |
|
|
count colored cells? by
DKY
I have a spreadsheet in which there is a calendar. On this calendar are
cells for the days. In these cells for the days we use colors for
Vacation (Purple),...
( 1 2 3)
|
|
21 |
356 |
|
|
sumif with or by
C Glenn
I'm trying to do this:
=SUMIF(B5:B12,OR("=D*","=?D*"),D5:D12)
It returns zero each time.
(BTW,
=SUMIF(B5:B12,"=D*",D5:D12)
and
=SUMIF(B5:B12,"=?D*",D5:D12)
( 1 2 3)
|
October 17th, 2005 11:56 PM
by C Glenn
|
21 |
265 |
|
|
Worksheet Naming by
Andy Sandford
Hi All
Is it possible to have the name of a worksheet change based on a value in a
cell within that worksheet?
e.g. data to be input in a cell relates to the...
( 1 2 3)
|
|
21 |
339 |
|
|
Formula to rid of DIV/o! by
Sean
hello,
Say A2 = 5.00, B2=0 C2 = DIV/O! - I would like for this to
be blank or show a zero...is this possible?
Thanks,
Sean
( 1 2 3)
|
|
21 |
299 |
|
|
|
June 3rd, 2010 09:42 AM
by steve
|
21 |
3,798 |
|
|
|
|
21 |
356 |
|
|
|
May 19th, 2005 11:07 AM
by paul
|
21 |
1,148 |
|
|
|
|
21 |
308 |
|
|
3D Ranges by
David
I am looking for a very simple piece of code illustrating the format for a
"3D" range ie one that spans more than one worksheet. Can anyone help. the MS
help...
( 1 2 3)
|
June 9th, 2005 06:11 PM
by David
|
21 |
363 |
|
|
Decimal to 24 hour clock please. by
Steved
Hello from Steved
1.43 to 1343
9.52 to 2152
3.17 to 1517
I have the above in decimal please a formula to 24hour clock as above
ie 3.17 to become 1517 not...
( 1 2 3)
|
June 9th, 2005 07:16 AM
by Steved
|
21 |
310 |
|
|
Excel function for tables by
rbrownlee
I have a table that has been created in excel that lists mileage from one place to the other. The rows all have headers for starting points, and the columns...
( 1 2 3)
|
|
21 |
244 |