Lookup value partaining in a particular month.

[Amit_KK]

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.

 

[GraH - Guido]

Hi Amit_KK, care to upload a small sample dataset.

 

[Amit_KK]

Hi attached the sample data file for reference..



Thanks

 

[herofox]

in Query 1
in cell M5 ,you can use this

=SUMIFS($F:$F,$C:$C,$K$5,$D:$D,$L$5)

Query 2 in cell N11 ,you can use this =SUMIFS($F:$F,$C:$C,"<="&$L$11,$C:$C,">="&$K$11,$D:$D,$M$11)

 

[p45cal]

You can also use a pivot table and a timeline.

 

[Amit_KK]

Nice idea, thanks..