Wednesday, April 25, 2012

yogi_Using SUMIF Function And Wild Card * With Date Entries In Google Docs Spreadsheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #515    Apr 25, 2012     www.energyefficientbuild.com.


user Firevelociraptor said: 
Google Excel Sum If Help I would like to do a sumif function that is like Excel's wildcard. 
This is the example: =sumif(B:B,"*January*",D:D) So that, the search in column B will come up with the corresponding prices in column D even when the date is formatted to include the day and year. 
Thanks. 
April 
--------------------------------------------------------------------------
following is a discussion on and a solution to the problem