Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
what am i doing wrong with my sumproduct()?
A1 = 7/1/2008 (thats July 1st 2008) D1 = 13 E1 = 11 just to make calculating eazy i followed the 13 and 11 pattern all the way to AH1 so F1 = 13 G1 = 11 and so on (eventually these numbers will change randomly) heres the formula thats failing =SUMPRODUCT(((D1:AH1)-120)*((D1:AH1)-12)*(WEEKDAY(A1+ROW(A1:A31))<6)) so if the number is greater then 12, i subtract 12...except if i find the number on a friday(6) so in this case, i should get 14 but i am getting 416 i can simply so this =SUMPRODUCT(((D1:AH1)-120)*((D1:AH1)-12)) and i get 16 but i know July 2008 had 2 fridays 7/11/8 and 7/25/8. so they should not be counted. evaluate formula looks ok it has weekday(39630+{1:2:3...:30:31} then it adds up ok then it shows the days properly then it shows the proper number of true Falses then it just gets wierd any help? please |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct and weekday from mm/dd/yyyy format? | Excel Discussion (Misc queries) | |||
weekday() help please? | New Users to Excel | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
Difficult formula SUMPRODUCT,MATCH,WEEKDAY | Excel Worksheet Functions | |||
WEEKDAY using IF | Excel Discussion (Misc queries) |