Counting formula
Fri, 19 Mar 2010 19:41:01 -0700
I need a formula to sum on the cells that match a variable in another cell
A B C D E F G H I
1
2 Bo Jim Ron
3 3 2 6
4 1 2 3 4 5 6 ? ? ?
What I need to be able to do is sum the number of columns (A4:F4) that
matches the numbers in G3:I3. So ...
|
Moving Cell Formula
Fri, 19 Mar 2010 16:50:01 -0700
I have a spreadsheet with a summary page and several worksheets following.
My formula calculates from a column of data that is updating with new
information each week. How can I set up a formula to automatically select
the cell below with the new data?
...
|
Vlookup problem
Fri, 19 Mar 2010 16:36:01 -0700
I am having a problem with a vlookup fromula returning an #N/A value when
using a cell with another vlookup formula as the lookup_ value. I created
this same spreadsheet a year ago and it worked fine. I even opened the old
one and I can't see any differences at all. I'd appreciate any help anyone
can give.
...
|
Making an excel sheet so formulas can not be deleted in the sum to
Fri, 19 Mar 2010 15:04:01 -0700
Making an excel sheet so formulas can not be deleted in the sum total yet in
the other cells used to add up to the sum total cell a numer can be added.
I tryed locking only the cells that contain the formula under the Format
Protect tab, but the formula could still be deleted by hitting the space bar
or ent ...
|
RE: Protect cell but allow copy command?
Fri, 19 Mar 2010 13:49:02 -0700
Does this work the same way in 07? I have tried it several times. However,
it will not allow me to copy and insert a row without entering the password.
"Jay" wrote:
> Yes, go to the cell right click and select format cells from the pop-up menu.
> Then go the very last right tab and place a check mark in ...
|
RE: Protect cell but allow copy command?
Fri, 19 Mar 2010 13:47:01 -0700
"Jay" wrote:
> Yes, go to the cell right click and select format cells from the pop-up menu.
> Then go the very last right tab and place a check mark in locked and hidden
> check boxes, click OK. Then go back to the main sheet and select protection
> from the "Tools" menu, there, select "Protect Workshe ...
|
Weeknum Within a Range
Fri, 19 Mar 2010 13:31:58 -0700 (PDT)
We are trying to get the number of rows in a range that are in the
same week as a date. The date is in A1 below. The attempted formula is
below. We did use "CTL + SHIFT+ENTER" to create the array. The data is
in the area labeled "DATA!D3:D19".
Is this the wrong approach?
A1 = 2/21/2010
A2 #VALUE!
Formul ...
|
|
|
sumproduct with 4 conditions
Fri, 19 Mar 2010 13:31:02 -0700
i need to have a single formula that will count the number of times 4
different conditions are met. I 2 types of members, in 3 different markets.
i need to identify, the member type A, from market A, during January, that is
not duplicated.
i have the date converted to a text field in column B (labeled all ...
|
If then between two dates
Fri, 19 Mar 2010 12:59:01 -0700
I am trying to distribute revenue evenly between two dates. I have in one
cell the beginning of the project. I have in another cell the end of the
project. One my spreadsheet, I am referencing the month to determine if it
falls betwen the project dates. I thought it was an if(and statement but it
doesn't ret ...
|
Posting the workbook
Fri, 19 Mar 2010 12:33:01 -0700
How can I post the workbook I am in so someone can help me with IF, INDEX and
MATCH combination formula? ...
|
