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

41 questions

Tagged
  • ×
  • ×
28
views
1
answer
no
votes
2020-07-31 01:16:55 +0200 Lupp

OR inside SUMIF

30
views
1
answer
no
votes
2020-07-20 20:02:20 +0200 erAck flag of Germany

Problem with SUMIF - maybe using dates

61
views
2
answers
no
votes
2020-04-09 10:36:36 +0200 Mike Kaganski flag of Russia

SUMIF with different Criteria values?

401
views
1
answer
no
votes
2019-07-04 16:45:43 +0200 Opaque

Countif / Sumif greater than zero

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

Calc - SUMIF based on cell background color

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

Why is this SUMIF not working?

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

err 509 in sumif

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

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

SUMIF on multiple cells if first cell ISBLANK?

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

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

sum with two test ranges

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

SUMIF column of same row

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

SUMIF + group by

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

550
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

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

sumif with cell reference?

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

SUMIF that count occurrencies

67
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 *

Resources

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

Contributors

pierre-yves samyn gravatar imagekarolus gravatar imagerobleyd gravatar imageLKeithJordan gravatar imageOpaque gravatar imageLupp gravatar imageJim K gravatar imageJohnSUN gravatar imageSchiavinatto gravatar imagem.a.riosv gravatar imageoweng gravatar imageTwisted Spur gravatar imageAl Vesper gravatar imageerAck gravatar imageptoye gravatar imageherry gravatar image