Hi
I want to create a spreadsheet where i can put multiple sumif criteria in a list and get the correct answer.
Se example book.
E.g if i want to sum the amounts in the B column refering to the account nr. in column A. i should get the value 300 and not 100 as i do in the spreadsheet.
Also important is that if i at a later point increase the List with account 2060 i should get the value 500.
All help is much appreciated
accounting.xlsx
Bookmarks