Creating a log of check payments

[mcgonma]

On the Payments tab in column O I have dollar amounts of payments received in cash and checks. In column Q there are payment types of either "Cash" or a numeric value for the check number.

I would like to have a Summary tab that pulls over the check payments based on what is designated as payment with a check number in column Q (or, conversely, does not have "cash" as the payment type).

What formula would I use on the Summary tab for this?

 

[My Aswer Is This]

I could supply a Vba solution. But you asked for a formula.
So if no one provides a Formula solution I will provide a Vba solution later today.

 

[JackDanIce]

Try:

=IF(Payments!Q2="Cash","",Payments!O2)