Sum of different accounts

V

V

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
 
P

Per Jessen

Hi

With your data in A1:C10, try this:

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

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

search and sum 1
Find then highlight in yellow 6
time_report_date-wise_employee-wise 6
Add Hours by Looping through Data Q 27
macro adding rows 8
Deleting blank cells w/o impacting other rows/columns 5
Reverse Index Match 2
Excel (or Access) Challenge 5

Top