Forum Discussion

Mazzarougle's avatar
Mazzarougle
Copper Contributor
Jun 06, 2023
Solved

SUMIF help

Hi,   I wonder if someone is able to help with a SUMIF formula, or even if it is possible please.   I’ve added a basic table of info for a visual below.  I have a financial ledger and I need t...
  • OliverScheurich's avatar
    Jun 06, 2023

    Mazzarougle 

    =SUM(SUMIFS($D$2:$D$10,$C$2:$C$10,A13,$B$2:$B$10,{"123";"234"},$A$2:$A$10,"01.01.2023"))

    You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.

Resources