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

33 questions

Tagged
  • ×
37
views
1
answer
no
votes
2018-08-24 14:04:14 +0100 erAck flag of Germany

err 509 in sumif

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

Sumif using multiple partial matches

887
views
2
answers
no
votes
2018-06-12 20:22:15 +0100 ChrisCrinkle

Calc: can you combine SUMIF and VLOOKUP?

70
views
1
answer
no
votes
2018-01-05 22:52:11 +0100 Lupp

SUMIF on multiple cells if first cell ISBLANK?

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

Add to total if there is data in another field?

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

sum with two test ranges

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

SUMIF column of same row

153
views
3
answers
no
votes
2017-03-31 13:10:52 +0100 Lupp

SUMIF + group by

59
views
1
answer
no
votes
2017-03-01 14:08:21 +0100 Mike Kaganski

How to use SUMIF when condition has a function?

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

How to SUMIF that tests if length of cell is 1

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

sumif with cell reference?

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

SUMIF that count occurrencies

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

How can I sumup column depending on string criterion ?

918
views
2
answers
no
votes
2016-02-21 08:34:36 +0100 oweng flag of Australia

sumif with wildcard *

35
views
no
answers
no
votes
2015-05-08 08:58:39 +0100 paradoxical

Sumif displays no results out cell reference

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

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

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

Convert Excel multi function formula to Calc [closed]

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

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

2k
views
1
answer
no
votes
2014-06-09 17:57:07 +0100 Pedro flag of Portugal

Does SUMIFS work in the latest version? [closed]

132
views
1
answer
no
votes
2014-05-09 13:28:32 +0100 Coda847

How to Sum Occurences [closed]

Resources

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

Contributors

Rugslug gravatar imageLKeithJordan gravatar imageROSt52 gravatar imageJohnSUN gravatar imageJim K gravatar imagerobleyd gravatar imageLupp gravatar imagekarolus gravatar imagem.a.riosv gravatar imageerAck gravatar imageoweng gravatar imageherry gravatar imagePedro gravatar imageTwisted Spur gravatar imageCoda847 gravatar imageCrazyFox gravatar image