Sumif current date due formula error

[asad khan]

Dear Sir,

I am enclosing an excel sheet in which i use sumif by today date

i only want use this formula only for current due balance by current date but its shows me all values as highlighted in due column i only want to see current due balance kindly help me out and check if there is more settings to add in this sheet


thanks

 

[NARAYANK991]

Hi ,

Please mention the cell reference where you want a formula , and indicate the output that the formula should give based on specific inputs.

Narayan

 

[asad khan]

i need formula in due column as i mentioned before so when is see the due column its show me only current due balance not all ok
thanks

 

[Khalid NGO]

Hi Asad,

Your question is not clear and there is no date less than today's date i.e 30th Nov 2017.

Please upload file with manually entered expected results.

Regards,

 

[asad khan]

OK but my prob is that I need current due balance not all receable bal in due col pl fit some formula. Thanks

 

[NARAYANK991]

OK but my prob is that I need current due balance not all receable bal in due col pl fit some formula. Thanks

Hi ,

This is the third time you are repeating the same thing , so I will also repeat the same thing I posted earlier and which Khalid has also written.

Upload a workbook which has at least 5 or 6 manually worked out outputs , so that we will know what the formula that we suggest should do.

Narayan