I am working with the formula below.

=SUMIF('Input 505 & 506'!$C$5:$C$63,$A6,'Input 505 & 506'!$D$5:$D$63)

It is comparing alpha characters and when it finds a match, it is
pulling a number that is sitting in a third column.

Some of the numbers may have decimals in them and I want this formula
to pull the number without any decimals. I would like to "round" the
number prior to it being pulled and summed. I know I can use:

{=SUM(TRUNC('Input 505 & 506'!$D$5:$D$63))} an array
or
=SUMPRODUCT(TRUNC('Input 505 & 506'!$D$5:$D$63))

Is there anyway to squeeze this into the 3rd argument of my SUMIF
function? I've not had any luck so far....


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=519792