Ask Your Question

Deever's profile - activity

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