SUMPRODUCT update formula needed.

[Frazzfreeman]

hi guys!!!

I have a SUMPRODUCT formula on the attached sheet which is setup to total payments outstanding Dependant on month over due (top sheet), i would like to change this so it totals up days over due (bottom sheet).....

Hope it makes sense and someone can help??

Thanks...

[NBVC]

Try these in A65:D65

=SUMIF(B46:B47,"<"&$E$8-90,E46:E47)

=SUMIF(B46:B47,">="&$E$8-90,E46:E47)-C65

=SUMIF(B46:B47,">="&$E$8-60,E46:E47)-D65

=SUMIF(B46:B47,">="&$E$8-30,E46:E47)

[Frazzfreeman]

Thanks for the response...

That seems to be what i am after but i have changed the date format in E8 and now it will not work. Cant find the correct date format...... So annoying!!

Thanks for your help!!

[NBVC]

You spelled November wrong

[Frazzfreeman]

Ha ha, what a nooob!!

Cheers for your help, much appreciated!!

[Frazzfreeman]

Thought i had this sorted but the 61-90 days doesn't not seem to function correctly and i cant for the life of me see why???

Please help...

[NBVC]

Maybe to be safer use formula in C38:

=SUMIF(C16:C31,">="&$F$11-90,F16:F31)-SUMIF(C16:C31,">"&$F$11-60,F16:F31)

and in D38:

=SUMIF(C16:C31,">="&$F$11-60,F16:F31)-SUMIF(C16:C31,">"&$F$11-30,F16:F31)

leave the others as are.

[Frazzfreeman]

That appears to work... Any idea's why the other formula seemed to be conflicting???

[NBVC]

Because I think I should have subtracted the Sum of the previous 2 results...

i.e. =SUMIF(C16:C31,">="&$F$11-90,F16:F31)-SUM(D38:E38)

[Frazzfreeman]

OK, thanks for all your help!!!!!!!