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

35 questions

Tagged
  • ×
53
views
1
answer
no
votes
2019-02-07 15:33:59 +0200 erAck flag of Germany

Why is this SUMIF not working?

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

err 509 in sumif

256
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

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

Calc: can you combine SUMIF and VLOOKUP?

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

SUMIF on multiple cells if first cell ISBLANK?

28
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

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

SUMIF column of same row

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

SUMIF + group by

69
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?

242
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

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

sumif with cell reference?

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

SUMIF that count occurrencies

52
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

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

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

715
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]

495
views
1
answer
no
votes
2014-07-23 01:15:12 +0200 m.a.riosv flag of Spain

How to Sum only if range totals greater than 3 [closed]

Resources

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

Contributors

robleyd gravatar imageRugslug gravatar imageLupp gravatar imageLKeithJordan gravatar imageJim K gravatar imageROSt52 gravatar imagekarolus gravatar imagem.a.riosv gravatar imageJohnSUN gravatar imageerAck gravatar imageTwisted Spur gravatar imageoweng gravatar imageptoye gravatar imageherry gravatar imageBed Intruder gravatar imageCrazyFox gravatar image