Hot answers tagged formulas
3
In Google Spreadsheets, OR is a function (with any numbers of arguments), so you would write
IF (OR(C7 = "U.S.A."; C7 = "Canada"); "The Americas"; "Europe")
See the example spreadsheet I set up.
Also, check the Google Spreadsheets function list.
2
Yes, by FILTERing the array:
= JOIN( " vs " ; FILTER(C10:C14; NOT(C10:C14 = "") ))
Thus, the JOIN method will only operate on non-empty cells.
I have set up an example spreadsheet.
Also, check the Google Spreadsheets function list (search for FILTER).
1
Try this formula in google - spreadsheets
=arrayformula(SUM(('Survey Data'!F2:F200="Divisional Exec")*('Survey Data'!A2:A200="Act")))
In Excel - assuming Excel 2007 or later you can use COUNTIFS
=COUNTIFS('Survey Data'!F2:F200,"Divisional Exec",'Survey Data'!A2:A200,"Act")
1
The following Google Apps Script (GAS) will achieve your goal automatically:
function CUMSUM(array) {
// set active spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet();
// get active sheet
var sh = ss.getActiveSheet();
// get data (2D array)
var aTest = sh.getRange(array).getValues();
// convert 2D array to 1D array
var aData = ...
1
If you're thinking about "loop and if statements", you should look into Google Apps Scripts.
Other than that, it seems you're looking for the TRANSPOSE function, in conjunction with the FILTER function. Take a look at the Google Spreadsheets Function List.
If you can tell me the purpose of the Purchase column in your example, I might be able to set up a ...
1
I've searched the internet (Google, search tools, custom range) for references of the ISBLANK function pre-dating the OP's question. The ISBLANK function already existed during the time of asking: ISBLANK reference before 01/12/2009
Therefore this function will suffice:
=IF(ISBLANK(A2)=TRUE;"Blank cell";"Not blank")
There is however one thing to take in ...
Only top voted, non community-wiki answers of a minimum length are eligible
