 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in the same sheet.
That will basically summarize all the values on my historical sheet and group them by my A1 cell name.
I need a second condition so that I can group rows by month also, and the SUMIF does not seem to allow for a second condition or an AND to concatenate a second clause. Any genius here got a simple solution?
The answers you seek lie herein:
http://singletrackmag.com/forum/topic/just-learnt-a-powerful-new-excel-technique
SUMPRODUCT is your friend.
If still stuck later then either I or someone even less dumb than me can probably help out.
Or if you're using Excel 2007 or later you can use SUMIFS and multiple conditions.
two posts and I think we have the answer already. STW you rock.(Esp stoner and danti cheers)
Has no-one suggested a VLOOKUP yet 🙄