• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup value partaining in a particular month.

Amit_KK

New Member
Hello Friends, Hope you all are good.

I am stuck in a problem, I have some monthly sales data. There can be multiple bill for various services rendered to parties in a month.
Now I wanted to lookup a sales bill using company name of a company for a particular service in a particular month.
suppose I wanted to lookup the invoice amount for Rent service of XYZ company in suppose Jan 20 month.
How do I do this, Please advise.

Thanks.
 
Hi attached the sample data file for reference..



Thanks
 

Attachments

  • Sample Data File.xlsx
    80.1 KB · Views: 6
in Query 1
in cell M5 ,you can use this
Code:
=SUMIFS($F:$F,$C:$C,$K$5,$D:$D,$L$5)
Query 2
in cell N11 ,
you can use this
Code:
=SUMIFS($F:$F,$C:$C,"<="&$L$11,$C:$C,">="&$K$11,$D:$D,$M$11)
 

Attachments

  • Sample Data File2.xlsx
    66.6 KB · Views: 2
Last edited:
You can also use a pivot table and a timeline.
 

Attachments

  • Chandoo44141Sample Data File.xlsx
    106.4 KB · Views: 3
Back
Top