SUMIF

[ExcelRoy]

Hi,

Can i please ask for some help, i am looking for a formula to show a sum of column C if E4 is matched in column D and F24 is matched in column E

Any help appreciated

Thanks

 

[Toadstool]

Hi ExcelRoy,

Does this work for you?

ExcelRoy2.xlsx
	B	C	D	E	F
1	Formula	Column C	Column D	Column E	Column F
2	1131	22	Pig	Fish
3		44	Cat
4		66		Dog
5
6			Frog
7				Sycamore
8				Oak
9		222	Dog
10		333
11		444
12
23
24					Oak
Sheet1

Cell Formulas
Range	Formula
B2	B2	=IF(OR(ISNA(MATCH($E$4,D:D,0)),ISNA(MATCH($F$24,E:E,0))),"",SUM(C:C))

 

[ExcelRoy]

Hi Toadstool,

Many thanks but the totals are only if Columns C and D match E4 and F24

I think this formula totals everthing within the range?

Many thanks

 

[Fluff]

Maybe
=SUMIFS(C:C,D:D,E$4,E:E,F$24)

 

[ExcelRoy]

Awesome Fluff, thanks

Thanks for trying to help Toadstool!

 

[ExcelRoy]

Going one step further can this formula be used or similar to show column B "Name" when the matches are made?

 

[Fluff]

Can you please post some sample data using the XL2BB add-in?

 

[ExcelRoy]

LEGO elements.xlsx
	B	C	D	E	F
37	885-1	1	3957	OldGray	Antenna 4H (Pic)
38	885-1	2	3062a	TrBlue	Brick 1 x 1 Round with Solid Stud (Pic)
39	885-1	1	3633	OldGray	Fence 1 x 4 x 1 (Pic)
40	885-1	1	3838	Red	Minifig Accessory Airtanks (Pic)
41	885-1	1	3626ap01	Yellow	Minifig Head with Solid Stud and Standard Grin Pattern (Pic)
42	885-1	1	970c00	Red	Minifig Hips and Legs (Complete) (Pic)
43	885-1	1	973p90	Red	Minifig Torso with Classic Space Pattern (Pic)
44	885-1	2	3024	TrRed	Plate 1 x 1 (Pic)
45	885-1	1	3839a	OldGray	Plate 1 x 2 with Handles Type 1 (Pic)
46	885-1	1	3460	OldGray	Plate 1 x 8 (Pic)
47	885-1	2	3022	OldGray	Plate 2 x 2 (Pic)
48	885-1	1	3034	OldGray	Plate 2 x 8 (Pic)
49	885-1	1	3298p90	OldGray	Slope Brick 33 3 x 2 with Classic Space Logo Pattern (Pic)
50	885-1	1	3933	OldGray	Wing 4 x 8 Left (Pic)
51	885-1	1	3934	OldGray	Wing 4 x 8 Right (Pic)
52	885-1	1	3829	OldGray	~Moved to 3829c01 (Pic)
53	885-1	1	193a	Red	~Moved to 3842a (Pic)
54	886-1	1	3957	OldGray	Antenna 4H (Pic)
55	886-1	1	3062a	TrGreen	Brick 1 x 1 Round with Solid Stud (Pic)
56	886-1	1	3838	OldGray	Minifig Accessory Airtanks (Pic)
57	886-1	1	3838	White	Minifig Accessory Airtanks (Pic)
58	886-1	1	3959	OldGray	Minifig Accessory Torch (Pic)
59	886-1	1	3626ap01	Yellow	Minifig Head with Solid Stud and Standard Grin Pattern (Pic)
60	886-1	1	970c00	White	Minifig Hips and Legs (Complete) (Pic)
61	886-1	1	973p90	White	Minifig Torso with Classic Space Pattern (Pic)
62	886-1	1	3794	OldGray	Plate 1 x 2 with 1 Stud (Pic)
63	886-1	2	122c01	OldGray	Plate 2 x 2 with Wheels in Red (Pic)
64	886-1	1	3020	OldGray	Plate 2 x 4 (Pic)
65	886-1	1	3795	OldGray	Plate 2 x 6 (Pic)
66	886-1	1	3039	OldGray	Slope Brick 45 2 x 2 (Pic)
67	886-1	4	3641	Black	Tyre (Pic)
68	886-1	1	3829	OldGray	~Moved to 3829c01 (Pic)
69	886-1	1	193a	White	~Moved to 3842a (Pic
70	889-1	1	3956	OldGray	Bracket 2 x 2 - 2 x 2 (Pic)
71	889-1	2	3787	OldGray	Car Mudguard 2 x 4 without Studs (Pic)
Set Inventories

 

[ExcelRoy]

So my desired result would list out like

885-1
886-1
889-1

(just examples as not all data is visable)

Thanks

 

[Fluff]

What are the values in E4 & F24?