Hi I have a spread sheet that has numours information per day.
In COl A we have a number of enters for a date (i.e there could be 3 entries for 01/01/10 and 2 for 02/01/10.
I would like Col K to look up col A and give me total for that day.
I have added an example and highlighted in red what I want this to show...
Many thanks
=sumproduct(--($a$2:$a$20=j2),($h$2:$h$20))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Given the condition is singular, no modification to source values is required and summation range dimensions match those of the criteria then I think a SUMIF would suffice
modify ranges to suit.
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
yep , i just leapt in there with the old sum product,wood for trees!
Works like a dream, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks