SUMIF problem

[timlh42]

This seems like it should be a very easy thing but I've really struggled with it.

I simply want to sum the numbers in column O9:O117 if the cell in column O is not blank and the adjacent cell in column V contains the word Truck.

Can someone please help me with this?

 

[jtakw]

Hi,

SUMIF:

Excel 2010
	N	O	V
1	12
9		2
10
11		3	Truck
12
13
14		5
15		9	Truck
Sheet1

Cell Formulas
Range	Formula
N1	=SUMIF(V9:V117,"Truck",O9:O117)

 

[timlh42]

Thanks! I tried that formula and I didnt get the correct results. However, when I tried it using that formula using only consecutive cells that contained data it works. Thats why I think somehow I need to use that formula but add criteria to not count blank cells in column O

 

[jtakw]

SUMIF will not SUM True Blank Cells and will Not SUM cells that may contain "" as a result of a formula, I suspect you have numbers in Column O that are not actual numbers but TEXT, or you may have leading and/or trailing SPACE(s) in Column V with the word Truck, and also does Column V matching cells ONLY says Truck or it could be "This is my Truck".

As you can see, I have True Blanks and "" in Column O, and the result is correct.
How are the numbers in Column O entered, manually or by formula, how do the values get in Column V?

Excel 2010
	N	O	V
1	12
9		2
10			Truck
11		3	Truck
12		4	Car
13
14			Truck
15		5
16		9	Truck
Sheet1

Cell Formulas
Range	Formula
N1	=SUMIF(V9:V118,"Truck",O9:O118)
O10	=""

 

[timlh42]

The values in column O are actually times which are auto populated by a formula. It is the result of begin time minu end time and is formatted as 08:30. I think you might be correct because when I do a =sum (O9:O117) I dont get accurate results but if I do =sumif(O9:O117,">0") then I get the correct results. However, my problem is that I dont want to sum the whole column. Only the cells with the word Truck in adjacent column v