Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EOMONTH as test criteria
Is it possible to use EOMONTH as a test criteria in a sumproduct array?
I have the EOMONTH set up as column headers on my worksheet to show a 7 month window of data (3 months prior, current month, and 3 months future), this will always be current based on the current date. I want to pull data from a separate work sheet based on monthly totals, but I would like to incorporate the EOMONTH formula into the sumproduct so the data stays current with the column headers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumProduct but sometimes don't test some criteria | Excel Worksheet Functions | |||
Test Cell For Multiple Criteria | Excel Worksheet Functions | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
Using Error Message as test Criteria | Excel Worksheet Functions | |||
results of "SUMIF" test criteria | Excel Worksheet Functions |