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

30 questions

Tagged
  • ×
34
views
1
answer
no
votes
2018-01-05 22:52:11 +0200 Lupp

SUMIF on multiple cells if first cell ISBLANK?

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

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

sum with two test ranges

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

SUMIF column of same row

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

SUMIF + group by

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

How to use SUMIF when condition has a function?

106
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

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

sumif with cell reference?

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

SUMIF that count occurrencies

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

737
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

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

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

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

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

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

How to Sum Occurences [closed]

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

SUMIF: apply function input range [closed]

5k
views
1
answer
no
votes
2013-06-14 09:41:23 +0200 m.a.riosv flag of Spain

sumif two criteria in different row/column [closed]

8k
views
3
answers
no
votes
2013-03-22 15:25:02 +0200 ROSt52 flag of Japan

Why does "" not work as criterion for SUMIF? [closed]

Resources

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

Contributors

karolus gravatar imageLupp gravatar imageJohnSUN gravatar imageRugslug gravatar imageJim K gravatar imagerobleyd gravatar imageROSt52 gravatar imagem.a.riosv gravatar imageLKeithJordan gravatar imageerAck gravatar imageoweng gravatar imageTwisted Spur gravatar imageherry gravatar imagePedro gravatar imageMike Kaganski gravatar imagekebs gravatar image