Sum up the values from one sheet and add them to another following certain conditions 2

[An Quala]

Hello @Peter_SSs Sorry I had to add few more details in the last query because last time it would not possible to focus on tiny details in post #5900910,

So I need to add these details,

1- Before summing up it should also check in Sheet "BOOK1" Column R,S,T to be "enabled", if not, ignore the values.

2- Add one more column which Sum up no of correspondence of that keyword in Column "Campaign Name (Information Only" (L) for example "ABC" occurs just 1 time in the sample data (screenshot attached) and columns R and S = "enabled" and Column B = "Campaign", so for row 3, it will look something like this, B3 = Campaign, R3 = enabled, S3 = enabled, L3 contained "ABC", then 1 occurrence and so on.

3- The number of rows in the data is not fixed, in this case it is 61, but it should be unlimited.

Thank you.

BOOK1

Book3
	B										L						R	S	T														AH	AI	AJ	AK	AL	AM	AN
1	Entity										Campaign Name (Informational only)						State	Campaign State (Informational only)	Ad Group State (Informational only)														Impressions	Clicks	Click-through Rate	Spend	Sales	Orders	Units
2	Keyword										Campaign ABC						enabled	enabled	enabled														100	10	10502.00%	10.00	100.00	5	6
3	Campaign										Campaign ABC						enabled	enabled															100	10	10602.00%	10.00	100.00	5	6
4	Bidding Adjustment										Campaign ABC							enabled															100	10	10702.00%	10.00	100.00	5	6
5	Bidding Adjustment										Campaign ABC							enabled															100	10	10802.00%	10.00	100.00	5	6
6	Ad Group										Campaign ABC						enabled	enabled	enabled														100	10	10902.00%	10.00	100.00	5	6
7	Product Ad										Campaign ABC						enabled	enabled	enabled														100	10	11002.00%	10.00	100.00	5	6
8	Keyword										Campaign ABC						enabled	enabled	enabled														100	10	11102.00%	10.00	100.00	5	6
9	Keyword										Campaign ABC						enabled	enabled	enabled														100	10	11202.00%	10.00	100.00	5	6
10	Keyword										Campaign ABC						enabled	enabled	enabled														100	10	11302.00%	10.00	100.00	5	6
11	Keyword										Campaign ABC						enabled	enabled	enabled														100	10	11402.00%	10.00	100.00	5	6
12	Product Targeting										Campaign ABC						enabled	enabled	enabled														100	10	11502.00%	10.00	100.00	5	6
13	Campaign										Campaign ABC						paused	paused															100	10	11602.00%	10.00	100.00	5	6
14	Bidding Adjustment										Campaign ABC							paused															100	10	11702.00%	10.00	100.00	5	6
15	Bidding Adjustment										Campaign ABC							paused															100	10	11802.00%	10.00	100.00	5	6
16	Ad Group										Campaign ABC						enabled	paused	enabled														100	10	11902.00%	10.00	100.00	5	6
17	Product Ad										Campaign ABC						enabled	paused	enabled														100	10	12002.00%	10.00	100.00	5	6
18	Keyword										Campaign ABC						enabled	paused	enabled														100	10	12102.00%	10.00	100.00	5	6
19	Keyword										Campaign ABC						paused	paused	enabled														100	10	12202.00%	10.00	100.00	5	6
20	Keyword										Campaign ABC						paused	paused	enabled														100	10	12302.00%	10.00	100.00	5	6
21	Keyword										Campaign ABC						paused	paused	enabled														100	10	12402.00%	10.00	100.00	5	6
22	Keyword										Campaign DEF						paused	paused	enabled														100	10	12502.00%	10.00	100.00	5	6
23	Keyword										Campaign DEF						enabled	paused	enabled														100	10	12602.00%	10.00	100.00	5	6
24	Keyword										Campaign DEF						enabled	paused	enabled														100	10	12702.00%	10.00	100.00	5	6
25	Keyword										Campaign DEF						enabled	paused	enabled														100	10	12802.00%	10.00	100.00	5	6
26	Keyword										Campaign DEF						enabled	paused	enabled														100	10	12902.00%	10.00	100.00	5	6
27	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13002.00%	10.00	100.00	5	6
28	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13102.00%	10.00	100.00	5	6
29	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13202.00%	10.00	100.00	5	6
30	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13302.00%	10.00	100.00	5	6
31	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13402.00%	10.00	100.00	5	6
32	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13502.00%	10.00	100.00	5	6
33	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13602.00%	10.00	100.00	5	6
34	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13702.00%	10.00	100.00	5	6
35	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13802.00%	10.00	100.00	5	6
36	Keyword										Campaign DEF						enabled	paused	enabled														100	10	13902.00%	10.00	100.00	5	6
37	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14002.00%	10.00	100.00	5	6
38	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14102.00%	10.00	100.00	5	6
39	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14202.00%	10.00	100.00	5	6
40	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14302.00%	10.00	100.00	5	6
41	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14402.00%	10.00	100.00	5	6
42	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14502.00%	10.00	100.00	5	6
43	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14602.00%	10.00	100.00	5	6
44	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14702.00%	10.00	100.00	5	6
45	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14802.00%	10.00	100.00	5	6
46	Keyword										Campaign DEF						enabled	paused	enabled														100	10	14902.00%	10.00	100.00	5	6
47	Keyword										Campaign DEF						enabled	paused	enabled														100	10	15002.00%	10.00	100.00	5	6
48	Keyword										Campaign DEF						enabled	paused	enabled														100	10	15102.00%	10.00	100.00	5	6
49	Keyword										Campaign DEF						enabled	paused	enabled														100	10	15202.00%	10.00	100.00	5	6
50	Keyword										Campaign DEF						enabled	paused	enabled														100	10	15302.00%	10.00	100.00	5	6
51	Keyword										Campaign DEF						enabled	paused	enabled														100	10	15402.00%	10.00	100.00	5	6
52	Keyword										Campaign GHI						enabled	paused	enabled														100	10	15502.00%	10.00	100.00	5	6
53	Keyword										Campaign GHI						enabled	paused	enabled														100	10	15602.00%	10.00	100.00	5	6
54	Keyword										Campaign GHI						enabled	paused	enabled														100	10	15702.00%	10.00	100.00	5	6
55	Keyword										Campaign GHI						enabled	paused	enabled														100	10	15802.00%	10.00	100.00	5	6
56	Keyword										Campaign GHI						enabled	paused	enabled														100	10	15902.00%	10.00	100.00	5	6
57	Keyword										Campaign GHI						enabled	paused	enabled														100	10	16002.00%	10.00	100.00	5	6
58	Keyword										Campaign GHI						enabled	paused	enabled														100	10	16102.00%	10.00	100.00	5	6
59	Keyword										Campaign GHI						enabled	paused	enabled														100	10	16202.00%	10.00	100.00	5	6
60	Keyword										Campaign GHI						enabled	paused	enabled														100	10	16302.00%	10.00	100.00	5	6
61	Keyword										Campaign GHI						enabled	paused	enabled														100	10	16402.00%	10.00	100.00	5	6
BOOK1

Control Panel

Book3
	A	B	C	D	E	F	G	H	I	J
1	Entity	Campaign Name (Informational only)	Impressions	Clicks	Click-through Rate	Spend	Sales	Orders	Units	Number of Campaigns
2	Keyword	ABC	900	90	1045.18	90	900	45	54
3	Keyword	DEF	3000	300	4185.6	300	3000	150	180
4	Keyword	GHI	1000	100	1595.2	100	1000	50	60
5	Product Targeting	ABC	100	10	115.02	10	100	5	6
Control Panel

Cell Formulas
Range	Formula
C2:I5	C2	=SUM(FILTER(INDEX(BOOK1!$AH$2:$AN$61,0,MATCH(C$1,BOOK1!$AH$1:$AN$1,0)),((BOOK1!$B$2:$B$61=$A2)*ISNUMBER(SEARCH(" "&$B2&" "," "&BOOK1!$L$2:$L$61&" "))),0))

 

[Fluff]

Duplicate to: Sum up the values from one sheet and add them to another following certain conditions

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.