Sumifs

[spycein]

Hello Everyone,
I have following table and need help on sum total of Value 1 column.

Value 1	Value 2
100.00	100.00
200.00	500.00
300.00	300.00
400.00	100.00

I am looking for a formula which would return value based on the following criteria:
If Value 1 = Value 2 then exclude that cell value and sum other values of Value 1 column.
From the above table example, my sum total should return value as 600 i.e. sum of column row number 2 and 4 since those two rows not matching with Value 2 column.

I hope i have explained my query properly.
Many thanks in advance.
Best Regards,

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

+Fluff 1.xlsm
	A	B	C	D
17	Value 1	Value 2		600
18	100	100
19	200	500
20	300	300
21	400	100
Main

Cell Formulas
Range	Formula
D17	D17	=SUMPRODUCT((A18:A21<>B18:B21)*(A18:A21))

 

[spycein]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

+Fluff 1.xlsm
	A	B	C	D
17	Value 1	Value 2		600
18	100	100
19	200	500
20	300	300
21	400	100
Main

Cell Formulas
Range	Formula
D17	D17	=SUMPRODUCT((A18:A21<>B18:B21)*(A18:A21))

@Fluff Thank you so much for your help.

 

[Fluff]

You're welcome & thanks for the feedback.