Sumif multiple values

1. Sumif multiple values

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  Register To Reply

2. Re: Sumif multiple values

=SUMPRODUCT(SUMIF(A4:A12,D4:D6,B4:B12))
Try the above formula
edit the ranges if needed   Register To Reply

3. Re: Sumif multiple values

the sumif should be
=SUMIF(A:A,D4,B:B)
BUT
why should you get 300 and not 100

you have 1 entry for account 1000 of 100 only
Are you trying to sum all entries that is in the LIST column ?

if so try
=SUMPRODUCT((A4:A12=D4:D12)*(B4:B12))  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 