Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I'm not sure how to ask this,
I am currently working on a spreadsheet that has an itemized worksheet depicting each budget approval (Sheet2). I have it tied into our complete budget so that it automatically adds and/or subtracts the amounts according to the date... =SUMIF('Sheet2'!$K:$K,"="&(TEXT(D$5,"mmm-yy")),'Sheet2'!$E:$E) ....but I also need it to be specific to the "BUD#" and "LINE#" (see below). SHEET2 A B C D E BUD # LINE # CAF Date Constructed Key Field Dollar Amount AUBUD 01 12/9/05 =TEXT(C1,"mmm-yy") $13,600.00 AUBUD 01 3/6/06 =TEXT(C2,"mmm-yy") 19,000.00 AUBUD 03 12/9/05 =TEXT(C3,"mmm-yy") $88,810.00 AUBUD 05 12/9/05 =TEXT(C4,"mmm-yy") $23,113.00 CPBUD 06 12/12/05 =TEXT(C5,"mmm-yy") $9,400.00 BLBUD 01 12/12/05 =TEXT(C6,"mmm-yy") $62,234.00 CPBUD 01 12/12/05 =TEXT(C7,"mmm-yy") $5,750.00 Is there a way to do this with multiple criteria? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
same cell from multiple sheets into one column | Excel Discussion (Misc queries) | |||
Sumproduct - multiple criteria in Column A | Excel Worksheet Functions |