Home |
Search |
Today's Posts |
#1
|
|||
|
|||
named Ranges question
Hello,
I defined some named ranges in one worshest of my Excel workbook. One is called "Application" and one is called "Date". I wrote a formula within a cell of a different worksheet to count the instances where Application equals a certain value and Date equals a certain value. However, my formula is not working correctly even though it matches the syntax on the MIcrosoft Excel tutorial site as well as the syntax I used in another workbook that is working fine. Any suggestions? My formula is: =SUMPRODUCT((Application,C3)*(Date,B5)) The result in the cell is not a number, but #VALUE! Thanks! John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Poor Workbook Performance due to Named Ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
Named Cell Ranges | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |