Sum total based on separate column criteria

[mcgonma]

in Column O i have dollar values.
In Column Q I have the source of the funds (cash or check number).

On a different Summary tab I want to have a sum total of all the cash payments in one line and all the check payments on another line.

Could you please help me with the best formula to use for obtaining each calculation?

 

[Aladin Akyurek]

Try something like...

=SUMIFS(O:O,Q:Q,"cash")

If this is not helpful, please try to elaborate on your question with more detail.

 

[mcgonma]

PERFECT! Thank you very much.

 

[Aladin Akyurek]

PERFECT! Thank you very much.

You are welcome.