Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to assist with Counting Dates
Is it possible to utilise the formula below , however, by just highlighting
the whole column as the range, as opposed to physically highlighting from A1:A1000. If i use this folrmula and highlight column A as opposed to A1:A1000 i get a NUM error =SUMPRODUCT(--(MONTH(A1:A100)=2),--(YEAR(A1:A100)=2009)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to assist with Counting Dates
SUMPRODUCT does not work with columns, at least not Excel 2003 - you have to
define the range edvwvw Dilly wrote: Is it possible to utilise the formula below , however, by just highlighting the whole column as the range, as opposed to physically highlighting from A1:A1000. If i use this folrmula and highlight column A as opposed to A1:A1000 i get a NUM error =SUMPRODUCT(--(MONTH(A1:A100)=2),--(YEAR(A1:A100)=2009)) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200905/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to assist with Counting Dates
SUMPRODUCT works with a defined range, such as A2:A100.
It don't works when you use the whole column. All the range in the formula must be of the same size. In 2007, you can use SUMIFS with whole column -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Dilly" wrote: Is it possible to utilise the formula below , however, by just highlighting the whole column as the range, as opposed to physically highlighting from A1:A1000. If i use this folrmula and highlight column A as opposed to A1:A1000 i get a NUM error =SUMPRODUCT(--(MONTH(A1:A100)=2),--(YEAR(A1:A100)=2009)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to assist with counting dates | Excel Discussion (Misc queries) | |||
Need Assist With Formula Creation | Excel Worksheet Functions | |||
Assist with Match Dates | Excel Discussion (Misc queries) | |||
Formula Assist | Excel Discussion (Misc queries) | |||
Making Array Formula, please assist! | Excel Worksheet Functions |