SumIf Function

[Steve 1962]

Hi

I am trying to have SumIf only sum values in column G that are >0. How do I incorporate the >0 into the following SumIf function (relating to column G) -

=SUMIFS($G$4:$G$1000,$C$4:$C$1000,R12,$D$4:$D$1000,S12).

Thanks

 

[Fluff]

How about
=SUMIFS($G$4:$G$1000,$G$4:$G$1000,">0",$C$4:$C$1000,R12,$D$4:$D$1000,S12)

 

[Steve 1962]

Works fine. Thanks very much.

 

[Fluff]

You're welcome & thanks for the feedback