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

25 questions

Tagged
  • ×
  • ×
75
views
1
answer
no
votes
2021-01-08 19:44:27 +0100 Chuck1991

This sum(sumifs()) works in Excel but not Calc. Why not?

62
views
1
answer
no
votes
2020-12-19 19:50:16 +0100 Schiavinatto flag of Brazil

Sumifs problem

75
views
1
answer
no
votes
2020-11-04 12:41:05 +0100 JohnSUN flag of Ukraine

Calc, sum based on two conditions and dates [closed]

36
views
no
answers
no
votes
2020-09-01 20:57:18 +0100 Sai

Does SUMIFS with INDEX solve this? & how to do it?

319
views
1
answer
no
votes
2020-05-29 20:30:23 +0100 JohnSUN flag of Ukraine

Sum if multiple criteria

92
views
1
answer
no
votes
2020-01-29 13:16:25 +0100 Opaque

SUMIFS using array as criteria

374
views
1
answer
no
votes
2020-01-01 10:29:50 +0100 Mike Kaganski flag of Russia

Calc: How to "OR" conditions in SUMIFS?

25
views
no
answers
no
votes
2020-01-01 09:24:21 +0100 BeOS

Calc: How to AND/OR several text patterns?

94
views
no
answers
no
votes
2019-05-27 16:02:26 +0100 aSystemOverload

How to use WildCard as part of SUMIFS

49
views
no
answers
no
votes
2019-04-19 12:35:15 +0100 Sums

Whats wroing with Sumifs formula.

1k
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

167
views
1
answer
no
votes
2017-08-28 15:28:18 +0100 JohnSUN flag of Ukraine

Sum up based on date in the same row [closed]

330
views
1
answer
no
votes
2017-08-03 13:14:49 +0100 Lupp

How to sum by year and month from external source [closed]

198
views
2
answers
no
votes
2017-07-11 23:21:42 +0100 Lupp

Having a cell reference for SUMIFS that should work as a wildcard [closed]

128
views
1
answer
no
votes
2016-10-29 22:05:02 +0100 mark_t flag of Canada

Why doesn't SUMIF take cell data? [closed]

788
views
2
answers
no
votes
2015-11-28 00:37:17 +0100 Lupp

will sumifs work across workbooks? [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]

724
views
2
answers
no
votes
2014-03-10 00:01:57 +0100 Regina flag of Germany

Column Label in a SUMIFS function gives an Err:502 [closed]

6k
views
2
answers
no
votes
2013-05-20 23:47:49 +0100 m.a.riosv flag of Spain

Sumifs alternative [closed]

Resources

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

Contributors

LeroyG gravatar imagem.a.riosv gravatar imageSai gravatar imageJim K gravatar imageOpaque gravatar imageJohnSUN gravatar imagekeme gravatar imageLupp gravatar imagerockorang gravatar imageerAck gravatar imagePedro gravatar imageinJesus gravatar imageMrAdventure gravatar imagemark_t gravatar imageRegina gravatar imageMike Kaganski gravatar image