MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pull data from sheet 1 to sheet 2

Posted by noir on November 09, 2001 10:56 AM

I have by data setup like this in sheet 1:


I would like to use =sum(if(payee="cash",amount,0)) to keep a running total of the cash i spend but, i do not know how to incorporate sheet 1 into the formula.

Any suggestions?


Posted by noir on November 09, 2001 10:58 AM

PS, i will record all sheet 1 cash totals from within sheet 2.

Posted by Aladin Akyurek on November 09, 2001 11:08 AM

Would it be:


what you want to do?