How to sum range

[EduPAz]

Hi,

Can someone please help me with this?

I have this:
Column A: Mike, Tim, Daniel, James
Column B: 1, -1, -1,0
Column C: 22, 44, 66, 88

What is the formula that allows me to add in one cell, all values from column C that have a value greater than 1 in column B?

I don't want to create a new column with a condition in every cell.

Thanks,

Edu

 

[Michael M]

So at the moment your data would return 0, but try this formula

Excel 2013/2016
	A	B	C
1	mike	1	22
2	tim	-1	44
3	dan	-1	66
4	jim	0	88
5			0
Sheet1

Cell Formulas
Range	Formula
C5	=SUMIF(B1:B4,">"&1,C1:C4)