Sum, SumIF Functions

[LaFonson]

I know I am quickly wearing out my welcome, but I have found a lot of help here!!

I need a sum of all data to the left of the decimal point.

Example: 1.5,2.0,3.5,5.0...would return a sum of all whole numbers to the left of the decimal, so this answer would be 11.

THANKS

[martindwilson]

is that a string or separate cells?
if seperate cells or if not use text to columns to split them then
=SUMPRODUCT(TRUNC(A1:D1))

[LaFonson]

Thanks so much, that worked!!