Lookup and add (sum) values

[desquaninc]

I have looked at videos but cant seem to make it work

I have an excel sheet with values(examples below) in column A broken down by months Jan - Dec

Coaching (Angella)

Sendout Cards

Legal Shield

Stella Orange (Copywrite Coaching)

Nimble

Prism Global Marketing

MailChimp

Speaker Univ Column B has the money spend on that item for each month. I would like to look up a value on the entire sheet and add all the money for that specific value somewhere on that sheet.

<colgroup><col></colgroup><tbody>
</tbody>

 

[BobUmlas]

If your table starts in A1 and what you're looking up is in Z1, say, then:
=SUM(OFFSET(A1,MATCH(Z1,A:A,0)-1,1,1,12))

 

[desquaninc]

Thank you for help, I tried that and maybe i didnt do it right, so i did a screen shot so you can see how its set up, maybe this will help

 

[GerryZ]

Hello desquaninc
If you like to post a nice and clean HTML screen-shot click the video link in my signature I can help you and show how to do it.
there are several good reasons to post a nice HTML screen-shot one of them is simply copy and paste it to Excel and start work with it, but when you post a picture I belive noone is so generus to write it in Excel!
bye

 

[desquaninc]

Thank you GerryZ, i hope this is the correct way

Excel 2003
	A	B	C
1	Biz Expenses	Payments
2
3	January
4	Coaching (Angella)	$833.33
5	Sendout Cards	$32.95
6	Legal Shield	$49.00
7	Stella Orange (Copywrite Coaching)	$999.00
8	Nimble	$15.00
9	Prism Global Marketing	$900.00
10	MailChimp	$10.00
11	Speaker Univ	$147.00
12	Instant Teleseminar	$67.00
13	Retreat Parking	$40.00
14	Dining Out	$73.94
15	Book Giveaways	$104.93
16	HubSpot	$758.10
17	Hopelifters (Speaking Event)	$100.00
18	USPS	$85.78
19	Greater Phx Chamber Networking Event	$40.00
20	PostNet Box Renewal	$77.83
21	Take The Lead Tix	$34.05
22	Office Supplies	$25.54
23	Bank Fees	$20.44
24	Paypal Monthly Fee	$19.99
25	eVoice	$9.95
26	Quickbooks Online	$13.77
27
28	February
29	Coaching (Angella)	$347.23
30	Sendout Cards	$32.95
31	Legal Shield	$49.00
32	Stella Orange (Copywrite Coaching)	$999.00
33	Nimble	$15.00
34	Prism Global Marketing	$900.00
35	MailChimp	$10.00
36	Speaker Univ	$147.00
37	Instant Teleseminar	$67.00
38	Baggage Fees	$40.00
39	Hotel (Vegas)	$466.73
40	Cab (Vegas)	$37.76
41	HubSpot	$758.10
42	Kendall Summerhawk - Resource	$7.00
43	Inside Edge (Conference Registration)	$288.00
44	FedEx Office (copies)	$29.89
45	Dining Out	$97.82
46	Parking	$45.00
47	Bank Fees	$74.94
48	Vegas Flight	$204.00
49	eVoice	$9.95
50	Quickbooks Online	$13.77
51
52	March
53	Coaching (Angella)	$347.23
54	Sendout Cards	$57.95
55	Legal Shield	$49.00
56	Stella Orange (Copywrite Coaching)	$999.00
57	Nimble	$15.00
58	Prism Global Marketing	$900.00
59	MailChimp	$10.00
60	Speaker Univ	$147.00
61	Instant Teleseminar	$67.00
62	HubSpot	$758.10
63	Skysong (Workshop Space)	$157.50
64	GPS (Dues)	$24.00
65	Office Space Rental (video shoot)	$45.97
66	Shipping Refund - Tracy Smith	$3.99
67	Money Order Fee	$5.00
68	Dining out	$102.47
69	USPS	$5.72
70	Silent Auction Donation Items	$37.60
71	FedEx Shipping Fees (Conference)	$192.16
72	Bank Fees	$245.00
73	eVoice	$9.95
74	Quickbooks Online	$13.77
75
76
77	April
78	Coaching (Angella)	$347.23
79	Sendout Cards	$32.95
80	Legal Shield	$49.00
81	Stella Orange (Copywrite Coaching)	$999.00
82	Nimble	$15.00
83	Prism Global Marketing	$900.00
84	MailChimp	$10.00
85	Speaker Univ	$147.00
86	Instant Teleseminar	$67.00
87	HubSpot	$758.10
88	Lisa Nichols Event	$148.50
89	Refund - Taylor Stevens	$450.50
90	Money Order Fee	$5.00
91	USPS	$3.79
92	Gala Materials	$21.10
93	Parking	$29.00
94	Dining Out	$20.80
95	Bank Fees	$91.00
96	eVoice	$9.95
97	Quickbooks Online	$13.77
Doyenne

 

[Rick Rothstein]

Let's say cell D1 contains the text you want to look up in Column A in order to sum up its values in Column B, and lets say Row 1000 is the last data row, then try this formula...

=SUMIF(A1:A1000,D1,B1:B1000)

 

[GerryZ]

Woooow!
I'm so glad you learned froma my video
But now which the question?
the table seems to have the same numbers?

 

[desquaninc]

thank you, Rick it worked, your the best