Round down with sumif

[EmmaTM]

Hi,

I am wanting to round down my result from this sum if to the nearest pound. I dont want to change the decimal places in format cells as this figure will be added to another later and I want the sum to exclude the pence for this calc only.

Thank you

This is my sumif:
=SUMIF(Cars!$C:$C,Summary!$F6,Cars!$M:$M)

 

[Joe4]

One way is to just take the integer portion of the result, i.e.

=INT(SUMIF(Cars!$C:$C,Summary!$F6,Cars!$M:$M))

 

[EmmaTM]

Amazing, thank you

 

[Joe4]

You are welcome.
Glad I was able to help!