If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sumproduct with mixed data?
Hi, I have a column that is predominately filled with dates i.e. 1/12/2010;
16/4/2010 etc, and my formula below counted the number of rows based upon the month and year of these dates, this worked well until now. Some fields within the column now have text instead of a date and this has now messed up my formula which returns a #value error. Any assistance you can give would be greately appreciated. Thanking you in advance. =SUMPRODUCT(N(MONTH('C:\Users\[monitor.xls]Adjusting Output'!$A$3:$A$10001)=3),N(YEAR('C:\Users\[monitor.xls]Adjusting Output'!$A$3:$A$10001)=2010)) |
Thread Tools | |
Display Modes | |
|
|