Saturday, October 11, 2014

yogi_Convert Month Name Into Month Number For Formula Using QUERY Function

                  Google Spreadsheet   Post  #1786
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-11-2014
post by  wbmatti:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/8RN9JDGTIGA)
Query Month Problem
Hi,

I am trying to build a Profit and Loss sheet with a dynamic forecast function.
Means, I want to show the profit or loss for the next months.

The Problem I have is the "where Month(D)=" function in the Cockpit sheet. (Cell C10)
Is there a way to make a formula like MONTH(D)="CELL" instead of MONTH(D)=10.


Cockpit!C10=SUM(query(Revenues!$A$1:$I$200; "Select C WHERE MONTH(D)=G19 AND E is NULL"))-SUM(query(Expenses!$A$1:$I$200; "Select C WHERE MONTH(D)=G19 AND E is NULL"))




Thanks a lot
-----------------------------------------------------------------------------------------------------------------



No comments:

Post a Comment