Forum Discussion
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 to extract amounts to be totalled on a summary page where certain information is true.
For example, if the date column is ‘Jan-23’, the name field is ‘Bob Smith’ and the code field is ‘123’ or ‘234’, it will add the amount fields together into a total for Bob Smith, any codes (‘345’) that don’t fit this criteria are then not added.
thanks in advance for your help.
=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.
3 Replies
=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.
- Wow OliverScheurich!
Tested on the live document & perfecto!
Is there a step by step guide somewhere that can help me get my head around SUMIF?Here is a comprehensive guide to SUMIF and many other Excel functions and formulas.
How to use the Excel SUMIF function (In Easy Steps) (excel-easy.com)