Wednesday, January 1, 2014

yogi_MultiConditional Sum Of Amounts Based On Specified Month For Dates And Specified Item

                                          Google Spreadsheet   Post  #1462
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-01-2014
post by garfolino question by NWIJN (http://productforums.google.com/forum/#!topic/docs/AJWjFcIqyrY/discussion)
Thank you for your answers on this and other Vlookup questions. 
I had a question. 
Example:

Bar    11/22/13   $75
Bar    11/30/13   $75
Bar    12/30/13   $75
Food   11/30/13 $100

etc. I'd like to create a formula that sums if = BAR  but only for entries in month of November. Is this possible? 
-----------------------------------------------------------------------------------------------------------------------------------------------------

No comments:

Post a Comment