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
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
