How to find the charges in multiple days

[rajjana]

Dear Friends,

please check attached excel sheet i will mentioned the detail about calculation what i need, please help me.

[cbatrody]

Hi,

Try the following formula in F5:

=INDEX($H$8:$J$13,MATCH(E5-D5,H$8:H$13,1),MATCH($C5,$H$8:$J$8,0))

See the attached file.

[JohnTopley]

formula

=VLOOKUP(E5-D5,$I$9:$K$13,MATCH($C5,$I$8:$K$8,0))

See attached

[rajjana]

No Friend i need this type20150909_184144.jpg

[JohnTopley]

=SUMPRODUCT(((E5-D5+1)>=$I$10:$I$14)*((E5-D5+1)-$I$10:$I$14),INDEX($J$10:$K$14,,MATCH(C$5,$J$9:$K$9,0)))

See attached

[JohnTopley]

You should have explained what you wanted in your post.

[rajjana]

sorry friends please drop this thread..