Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

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


Check out our Excel Resources

Re: Pull data from sheet 1 to sheet 2

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

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


Re: Pull data from sheet 1 to 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

========


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.