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

32 questions

Tagged
  • ×
25
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

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

Calc: can you combine SUMIF and VLOOKUP?

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

SUMIF on multiple cells if first cell ISBLANK?

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

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

sum with two test ranges

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

SUMIF column of same row

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

SUMIF + group by

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

How to use SUMIF when condition has a function?

139
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

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

sumif with cell reference?

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

SUMIF that count occurrencies

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

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

sumif with wildcard *

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

Sumif displays no results out cell reference

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

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

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

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

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

Does SUMIFS work in the latest version? [closed]

124
views
1
answer
no
votes
2014-05-09 13:28:32 +0200 Coda847

How to Sum Occurences [closed]

294
views
1
answer
1
vote
2013-12-02 15:20:26 +0200 Regina flag of Germany

SUMIF: apply function input range [closed]

Resources

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

Contributors

JohnSUN gravatar imageLupp gravatar imageRugslug gravatar imagem.a.riosv gravatar imageJim K gravatar imagerobleyd gravatar imageROSt52 gravatar imageLKeithJordan gravatar imagekarolus gravatar imageerAck gravatar imageoweng gravatar imageherry gravatar imagePedro gravatar imageTwisted Spur gravatar imageFitch gravatar imageRegina gravatar image