How to make a true and false statement which copies cost and adds to total value

[Carl Blance]

Hi there,

So I'm trying to make a friendly Excel Spreadsheet for my team, but I'm stuck on how I would do this certain thing I want to do

There are three costs 110 = J1 215 = K1 250 = L1

I want to create the following

If Cell G1, G2, G3 = 1 then + all three together in Cell E1

I would like to remove the cost if possible, but I'm not an Excel expert unfortunately.

 

[Peter_SSs]

Welcome to the MrExcel board!

Is either of these any use to you?

Excel Workbook
	E	F	G	H	I	J	K	L
1	575		1			110	215	250
2	575		1
3			1
Costs