MrExcel Consulting
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:

a1=payee
b1=amount

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?

Thanks,
Noir

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:

=SUMIF(Sheet1!A1:A100,"cash",Sheet1!B1:B100)

what you want to do?

Aladin

========