Sum of different accounts
 

Can anyone tell me a formula to help me find the sum of various cost area
For example, for the table below, I would like to find a total spent on
staionery, members and arts, preferably shown on a different worksheet

03/01/09 Stationery 20
06/01/09 Members 32
06/01/09 Arts 25
09/01/09 Stationery 36
10/01/09 Arts 24
12/01/09 Members 72
16/01/09 Members 40
21/01/09 Stationery 25
23/01/09 Arts 22

Sum of different accounts
 

Hi

With your data in A1:C10, try this:

=SUMIF(B2:B10,"=Stationery",C2:C10)

Regards,
Per

"V" skrev i meddelelsen
...
Can anyone tell me a formula to help me find the sum of various cost area
For example, for the table below, I would like to find a total spent on
staionery, members and arts, preferably shown on a different worksheet

03/01/09 Stationery 20
06/01/09 Members 32
06/01/09 Arts 25
09/01/09 Stationery 36
10/01/09 Arts 24
12/01/09 Members 72
16/01/09 Members 40
21/01/09 Stationery 25
23/01/09 Arts 22