LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
taisn
 
Posts: n/a
Default Is there a way to sum a column using criteria from multiple column

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
Sumproduct with a vLookup, multiple criteria Tom F Excel Worksheet Functions 3 May 6th 05 04:28 PM
same cell from multiple sheets into one column Kel Excel Discussion (Misc queries) 0 February 18th 05 12:53 AM
Sumproduct - multiple criteria in Column A briank Excel Worksheet Functions 2 January 6th 05 06:44 PM


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"