Bug 155758 - FUNCTION: suggestion for SUM.IF()
Summary: FUNCTION: suggestion for SUM.IF()
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-09 14:01 UTC by Michel COLLET
Modified: 2023-06-09 23:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
example for the suggestion for SUM.IF() (19.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-06-09 14:01 UTC, Michel COLLET 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michel COLLET 2023-06-09 14:01:03 UTC 
Created attachment 187812 [details]
example for the suggestion for SUM.IF()

I suggest accepting functions in the "criteria" parameter.

Examples:
 > SUM.IF(E6:M6;AND(>0;<100);E7:M7)
 > SUM.IF(E6:M6;OR(AND(>0;<100);AND(>200;<300));E7:M7)

A detailed example is joined.
Comment 1 m_a_riosv 2023-06-09 23:30:38 UTC 
I think SUM.IFS() that let's add several criteria, do what you need.
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sumifs.html?DbPAR=CALC#bm_id658066580665806