Excel 2007 : formula needed to add up and copy a lot of data to separate tab in SS for each month

[linzi]

<<See spreadsheet attached.>>

In "Sales Funnel" Tab there is an option for "Order Month" on far right. For each month selected I want to copy certain info over to the tab called "Orders . Forecast" tab.

Certain Info = ...

The tab "Orders . Forecast" tab should contain a total of CXT / XN / WLS / SP22m / SP29A / SP29B / SP29C / TRUCARE contracts ( SP21C that has "YES" selected in column W on Sales Funnel Tab) / Contracts (SP21B + SP21C minus TRUCARE contracts) , that can be obtained from "Sales Funnel" tab, and this should be the case for each month.


I'm sure it can be done, I'm just struggling with it.


Any help would be MUCH appreciated. Please contact if more info needed.

[linzi]

any thoughts on this one anyone?