Hot answers tagged worksheet-function
5
Simply copy your formula from that cell to each cell below. Copying formulas with relative references (those without $) adjusts them automatically.
I think you have your coordinates backwards, though. Cell C2 contains "1000" and cell B3 contains "50", so your formula in C3 should be =MINUS(C2,B3) (or =C2-B3).
4
This works, see F35 in your sheet:
SUMIF(E2:E33;">="&E35;B2:B33)-SUMIF(E2:E33;"<="&E36;B2:B33)
column E is done by calculating a value for the dates to be able to compare them (=VALUE(E1))
Note that separating the args for some reasons is done with ;
4
Column A can be the recurring cost. Column B can be the number of months in the recurrence. Column C can divide Column A by Column B to get the monthly cost. Then you can sum column C. For your last.fm example:
A2 = "9.00"
B2 = "3"
C2 = "=A2/B2"
The your total monthly cost would be the sum of Column C.
2
This will work. I've used the Named Ranges, Name and From. You don't have to use To at all, since your values are all contiguous. B2 is what I used as the value of the first BMI, you can just drag this formula down the column:
=IFERROR(INDEX(Name, MATCH(B2,From),1),INDEX(Name,1,1))
2
I've been able to find a solution for my problem. Using =ARRAYFORMULA(Sheet1!A1:A) in the top of a column Google Docs will update the whole column, without the need for functions in each cell. Thus, deleted or inserted rows will not cause trouble anymore.
I found this answer (by brettathds) at the Google Support forums.
2
Ok - this isn't simple but it can be done. There may be a more elegant way but here's a way that will work, using only the terms you are providing.
Take a range of cells as follows
Col A B C
2 1 300 2
3 2 450 4
4 3 700
5 4 900
6 5 1000
7 6 1200
Take these formulas:
Cell A10:
...
2
This little script will compare two ranges, as a formula:
function COMPARE(array1, array2) {
var array = [];
for(i=0; i<array1.length; i++) {
for(j=0; j<array2.length; j++) {
if(array1[i][0] == array2[j][0]) {
// the extra square brackets will make it a 2D array,
// aligning it vertically
...
1
Use the following formula to accomplish that:
=SUMIF(range;">"&0)
The range is of course the one you set it to be !!
EDIT 29-03-2013; 23:00 CEST
IMPORTANT: This is only valid if you work at least 70 hours per week, each week. It is just as important to know if you have worked less !! Therefore you need to change the way you calculate the ...
1
Assuming you have "BANK" in I3:I20 (as opposed to "AMEX") for bank payments, then I believe you can achieve your goal by reversing your logic (equal to "BANK", rather than not equal to "AMEX")...
Change the formula in F24 to:
=arrayformula(sumif(H3:H20 & I3:I20,E24:E33 & "BANK",D3:D20))
This will then populate cells F24:F33 with the appropriate ...
1
According to http://productforums.google.com/d/msg/docs/X8DuFNN8GZI/5SpFysHvB4EJ there is no formula that can do this.
If you happen to know something about the characteristics of the numbers in question, e.g. if you know that the sums are always greater than 45 and no individual number is, you could use that, e.g. SUMIF(1:8, ">45")
However, in the same ...
1
error: The xPath query given could not be evaluated. Please check the syntax of the query: //a/@href
The Error message says XPath could not be evaluated.
Here the problem is: you need to provide / target with proper XPath to retrieve the value.
Refer my sample XPath for this:-
=importXml("http://www.toysrus.com", ...
1
The solution below involves a very elegant and generally useful technique popularized by ahab, a Google Docs expert; I suppose he invented it. It uses matrix multiplication.
Move the label "Starting" to the last cell of the Description column, column D.
Move the starting balance to the last cell of the Amount column, column E.
Insert a new blank row 2. ...
Only top voted, non community-wiki answers of a minimum length are eligible
