Combining a sumifs and round in one statement

[ariel20029]

Hi, I am trying to combine round and sumifs in one statement but its not liking what I am doing . Is there an easy way to do this?

=ROUND(SUMIFS('2.3 Lines'!$T:$T,'2.3 Lines'!$F:$F,"Service"),0)

Thanks,
Sharon

 

[Special-K99]

"I am trying to combine round and sumifs in one statement"

Implying there is originally more than one statement.
So what are the original statements?

 

[VBABEGINER]

why dont you make cell format in rounded format..??

 

[RoryA]

What does "it's not liking" mean? Your formula is correct as posted.

 

[ariel20029]

Hi because I am also doing a formula off to the side to compare data and the format change only does not work with the formula I am writing- thanks

 

[ariel20029]

Hi- it would not let me hit enter so excel was not accepting the formula as I typed it. thanks,Sharon

 

[ariel20029]

I will try the formula again thanks for your response Sharon