count all cells containing "Blue"
Fri, 3 Oct 2008 11:13:00 -0700
I need a formula to count the following:
A1:A1000 is not blank + B1:B1000 is blank + C1:C1000 contains the word blue.
=Sumproduct((A1:A1000<>â?â?)*( B1:B1000=â?â?)*( C1:C1000=â?*blueâ?))??
Answer: 2
Col A Col B Col C
Red Lt Blue
Blue
Tan re ...
|
VBA code go to specific location in embedded document
Fri, 3 Oct 2008 09:49:29 -0700 (PDT)
From Excel I'm opening an embedded OLE object (Word document). Once
the document is open, I need to be able to go to a location in the
document (preferably by keyword search). Is this possible?
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address = "$A$4" Then
Set Obj ...
|
Help Please
Fri, 3 Oct 2008 08:38:28 -0700 (PDT)
what formula would I use to make my spreadsheet lookup only certain
data from a spreadsheet and give me the sum. I want to pull only the
sum of hours each forman worked on a different spreadsheet. I might
have 25 Foreman and 150 Welders. Can you help
Name Craft Pay Rate
John Doe ...
|
Automatic Save & Close after 30 min of inactivity
Fri, 3 Oct 2008 07:10:36 -0700 (PDT)
Is this easy to setup? I see options for backup save....but I need
the open file to save and close if inactive for 30 minutes.
Thanks! ...
|
Max Error
Fri, 03 Oct 2008 12:34:30 +0100
I have a column(A) in a worksheet formatted as numbers. Entering the
formula MAX (A1:A1000) returns the #VALUE! error, as some cells have the
reference #VALUE!
How can I filter out #VALUE!? ...
|
Merge more Excel file
Fri, 3 Oct 2008 03:37:06 -0700
Hi all,
is it possible to merge the content of several Excel file in a unique Excel
file?
Every file has the same structure (obviously different in content).
Now I'm doing it with cut&paste, but with several hundreds files is very
time consuming?
Has anyone idea?
Thanks in advance.
--
Luigi
http:// ...
|
Formula which includes new sheets too?
Fri, 3 Oct 2008 09:11:56 +0100
Hi all,
I don't know if this is possible, but any suggestions would be much
appreciated!
I have a spreadsheet with a few sheets, 1 for each site and then a Summary
sheet which displays totals.
eg. Site 1 shows how much has been fee'd for that site in each month, and
the Summary Sheet shows how much ha ...
|
|
|
Ecxel substraction
Fri, 3 Oct 2008 09:34:19 +0200
Hello,
I am doing some Excel-work recently, and came across this "strange feature"
:
A 87,600000000000000000000000000000
B 89,700000000000000000000000000000
B-A 2,100000000000010000000000000000
Another one:
A
84,70000000000000000000000000000000000000000000000000000000000000000000000000000 ...
|
Sorting using formula
Fri, 3 Oct 2008 08:10:28 +0200
I have the following rows
A B C D E
Bill A 5 1 Bill B 8
Bill B 8 2 Bill A 5
Bill C 2 3 Bill D 3
Bill D 3 4 Bill C 2
I column D I have this formula
=INDEX($A$1:$A$4,ROW(INDIRECT(ADDRESS(MATCH(LARGE($B$1:$B$4,C1),$B$1:$B$4,0),1))),1)
Th ...
|
IF Formula to Dada Validation
Thu, 2 Oct 2008 22:42:37 -0700 (PDT)
Hi All,
I want to get across the following:
I have dropdown list in colum A and in column b some information. In
coulum c I want to say (if the word in column a equals "fortnightly",
then multiply B and another cell)
For some reason it is not allowing me to put an if sum using the drop
down list.
Can ...
|
