Sum IF, but from previous date with data

[#1]

Hi,

I need to sum like below but for the previous applicable date, any ideas?

=SUM(IF(Type='XXXX',Amount))

[#2]

Great  stuff, thanks a lot sunindia!

[sunny_talwar]

Yup, not a problem buddy. Just make sure to test it out with 1 and 3 holidays also. I think the formula is def. going to work for 2 and 4 holidays because we had that in your sample. May have to refined for 1 and 3.

Best,

S