First time here? Check out the FAQ!

2019-03-05 00:33:20 +0100 | received badge | ● Notable Question (source) |

2018-11-14 12:53:04 +0100 | received badge | ● Popular Question (source) |

2018-11-14 00:55:51 +0100 | commented question | [Calc] Get address of value in range And how can this be done with two-dimensional arrays? Yes, the values are unique. |

2018-11-13 20:49:00 +0100 | asked a question | [Calc] Get address of value in range [Calc] Get address of value in range I have a range (A1:D9) of some (unambiguous) integer values. What I'd need is the a |

2017-12-18 17:59:00 +0100 | received badge | ● Famous Question (source) |

2017-12-18 10:45:53 +0100 | received badge | ● Notable Question (source) |

2017-09-12 22:00:38 +0100 | answered a question | SELECT WHERE Ah, sure! SUMPRODUCT again! Thank you so much, hope I don't need to ask this question a 3rd time! :) |

2017-09-12 22:00:33 +0100 | marked best answer | SELECT WHERE Hi folks! I have a sheet with columns A, B and C and liked to have in E1 the value of the cell in C where the cells in A and B have some specific values. In SQL I'd do: select C from Sheet1 where A='foo' and B='bar' How can this be done in Calc? |

2017-09-12 22:00:33 +0100 | received badge | ● Scholar (source) |

2017-09-12 18:47:12 +0100 | received badge | ● Popular Question (source) |

2017-09-12 15:55:33 +0100 | asked a question | SELECT WHERE SELECT WHERE Hi folks! I have a sheet with columns A, B and C and liked to have in E1 the value of the cell in C where |

2017-04-19 11:20:53 +0100 | commented answer | COUNTIF calculated values without filling them to cells Thanks for the hint! |

2017-04-19 11:19:57 +0100 | edited answer | COUNTIF calculated values without filling them to cells Hello? No one with an idea? EDIT: First of all, this link works much better! :) https://www.dropbox.com/s/theitapov8aad |

2017-04-19 11:19:57 +0100 | received badge | ● Editor (source) |

2017-04-19 03:00:19 +0100 | received badge | ● Enthusiast |

2017-04-18 22:24:04 +0100 | received badge | ● Notable Question (source) |

2017-04-18 12:21:01 +0100 | received badge | ● Popular Question (source) |

2017-04-18 10:02:09 +0100 | answered a question | COUNTIF calculated values without filling them to cells Hello? No one with an idea? |

2017-04-13 14:19:52 +0100 | edited question | COUNTIF calculated values without filling them to cells COUNTIF calculated values without filling them to cells Hi folks! For the "profit" column (B), I'd need to count the va |

2017-04-13 14:07:55 +0100 | asked a question | COUNTIF calculated values without filling them to cells COUNTIF calculated values without filling them to cells Hi folks! For the "profit" column (B), I'd need to count the va |

2017-03-31 19:46:51 +0100 | commented answer | SUMIF + group by Wow, thank you so much! Already used SUMPRODUCT for weighted averages but didn't know that it can apply here, too! |

2017-03-31 19:14:42 +0100 | received badge | ● Popular Question (source) |

2017-03-30 23:00:27 +0100 | answered a question | SUMIF + group by And here come the links to the images: Source table: http://imgur.com/j3ZkahT Result table: http://imgur.com/KJQQ51h |

2017-03-30 22:58:27 +0100 | asked a question | SUMIF + group by SUMIF + group by Hi folks! In a Calc sheet, I'd like to sum all daily incomes grouped by month The formula should |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.