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....
Bookmarks