Created mini database/criteria/table spreadsheet on a Mac platform over last 10
yrs. Now I am switching to a PC platform. The spreadsheet had the following:
A B C D
1 DATE EXPENSE AMOUNT DESCRIPTION
2 AMOUNT
3 =DSUM(DATABASE,"AMOUNT",CRITERIA) This formula in C2
4 RENT01 {=TABLE(,B2)} This in B4..B5..B6..a few more
5 MISC01
A B C D
20 DATE EXPENSE AMOUNT DESCRIPTION
21 12/12/01 RENT01 $100.00 Jan
22 12/12/01 MISC01 $100.00 Yard
Each entry from C20 down would CUM in upper section B4 etc.
Can someone help me create this in latest Excel for Windows ?
Can not locate same pieces in windows version
to recreate..
I remember highlighting the info in Row A clicking
CRITERIA then highlighting A20-D150 click DATABase
then somhow using the TABLE feature for the CUM area B2-B6 or so..
I would appreciate any help..
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.