adding values if they occure in an array

[Colleen45]

I'm having a little problem putting a formula together. firstly I'd like to check if anyvalues (text) accur in column AI19:AI1000 (these text values are in BO19:BO46), when there is a match, the formula needs to add values found in BB19:BB1000
for example if there is a match from BO19:BO46, found in AI19:AI100, it should add those values to give one total, Hope I have made sense
Thanks

 

[hiker95]

Colleen45,

Excel Workbook
	AI	BB	BO	BP
19	aaa	1	aaa	111
20	ab	2	ab	7
21	ac	7	ac	12
22	aaa	100	c	19
23	c	3	cc	38
24	cc	33	ccc	305
25	ccc	300
26	c	6
27	aaa	5
28	ab	5
29	ac	5
30	aaa	5
31	c	5
32	cc	5
33	ccc	5
34	c	5
35
Sheet1

The formula in cell BP19 copied down to BP46:

=SUMIF($AI$19:$AI$1000,$BO19,$BB$19:$BB$1000)

 

[Colleen45]

Hello Hiker,

Yes this will be perfect, although I need to make minor additions as there a few more variables to take into account, you've certaily hit this on the mark. Thank you so much for your help.
Kind Regards and Blessings.

 

[Colleen45]

and of course I learnt the SUMIF function - thank you

 

[hiker95]

Colleen45,

You are very welcome.

there a few more variables to take into account

Look into SUMIFS for more variables.