Ask Your Question
RSS
Sort by » date activity ▼ answers votes

37 questions

Tagged
  • ×
40
views
1
answer
no
votes
2019-07-04 16:45:43 +0200 Opaque

Countif / Sumif greater than zero

95
views
2
answers
no
votes
2019-05-30 19:41:08 +0200 jmz

Calc - SUMIF based on cell background color

153
views
1
answer
no
votes
2019-02-07 15:33:59 +0200 erAck flag of Germany

Why is this SUMIF not working?

263
views
1
answer
no
votes
2018-08-24 14:04:14 +0200 erAck flag of Germany

err 509 in sumif

353
views
1
answer
1
vote
2018-06-21 10:22:30 +0200 Jim K flag of United States of America

Sumif using multiple partial matches

2k
views
2
answers
no
votes
2018-06-12 20:22:15 +0200 ChrisCrinkle

Calc: can you combine SUMIF and VLOOKUP?

146
views
1
answer
no
votes
2018-01-05 22:52:11 +0200 Lupp

SUMIF on multiple cells if first cell ISBLANK?

29
views
1
answer
no
votes
2017-09-28 18:45:01 +0200 Jim K flag of United States of America

Add to total if there is data in another field?

30
views
1
answer
no
votes
2017-07-31 02:22:43 +0200 m.a.riosv flag of Spain

sum with two test ranges

196
views
1
answer
no
votes
2017-07-24 06:12:28 +0200 robleyd flag of Australia

SUMIF column of same row

247
views
3
answers
no
votes
2017-03-31 13:10:52 +0200 Lupp

SUMIF + group by

77
views
1
answer
no
votes
2017-03-01 14:08:21 +0200 Mike Kaganski flag of Russia

How to use SUMIF when condition has a function?

295
views
2
answers
1
vote
2017-02-28 14:00:54 +0200 karolus flag of Germany

How to SUMIF that tests if length of cell is 1

124
views
2
answers
no
votes
2016-11-05 04:34:02 +0200 mark_t flag of Canada

sumif with cell reference?

45
views
1
answer
no
votes
2016-10-20 11:13:52 +0200 pierre-yves samyn

SUMIF that count occurrencies

55
views
1
answer
no
votes
2016-04-29 18:49:01 +0200 JohnSUN flag of Ukraine

How can I sumup column depending on string criterion ?

1k
views
2
answers
no
votes
2016-02-21 08:34:36 +0200 oweng flag of Australia

sumif with wildcard *

36
views
no
answers
no
votes
2015-05-08 08:58:39 +0200 paradoxical

Sumif displays no results out cell reference

11k
views
1
answer
no
votes
2015-01-28 19:29:52 +0200 Lupp

How to use sumif with condition 'not in list'?

737
views
2
answers
no
votes
2014-10-25 19:30:25 +0200 m.a.riosv flag of Spain

Convert Excel multi function formula to Calc [closed]

Resources

Did you find this site useful? Support the LibreOffice community!

Contributors

karolus gravatar imageOpaque gravatar imagerobleyd gravatar imageLKeithJordan gravatar imageLupp gravatar imageJohnSUN gravatar imageJim K gravatar imagem.a.riosv gravatar imageRugslug gravatar imageROSt52 gravatar imageoweng gravatar imageerAck gravatar imageherry gravatar imageptoye gravatar imageTwisted Spur gravatar imageNewerCalcUser gravatar image