I need to sum the data in column 'C' if it falls within specified date range in column 'A' and is of specified type in Column 'B'. Help!
I need to sum the data in column 'C' if it falls within specified date range in column 'A' and is of specified type in Column 'B'. Help!
=SUMPRODUCT(--(A4:A11>=D1),--(A4:A11<=D2),--(B4:B11=D3),C4:C11)
Assumptions:
D1 contains start date
D2 contains end date (both dates are inclusive)
D3 contains type of interest
Richard
Richard Schollar
Microsoft MVP - Excel
=SUMPRODUCT(--($A$4:$A$11>=DATE(2009,1,4)),--($A$4:$A$11<=DATE(2009,1,10)),--($B$4:$B$11="one"),$C$4:$C$11)
the date references etc can of course be references to cells containing the criterion.
for more info. on Sumproduct see: http://www.xldynamic.com/source/xld.SUMPRODUCT.html
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi,
It's not clear, at least to me, what you mean by 'falling within a specified date date range', what date range?
Can you give an example of what results you expect - and where and why.
Rgds
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks