Select data on basis multiple vertical criteria

**sanjuss2** · 10-27-2021, 05:07 AM

Hi,
Please find attachment in which i have 2 tables
1. Data Table
2. Result

I want result must be change as per the date specified.....

**Bo_Ry** · 10-27-2021, 05:50 AM

Please try at B20

=SUMIFS(INDEX(Data,,MATCH(TEXT($D$17,"dd-mm-yyyy"),Data[#Headers],)),$A$4:$A$13,$A20,$B$4:$B$13,B$19)

**sanjuss2** · 10-27-2021, 07:06 AM

Thank you so much

I used your earlier formulas as follows
=SUMPRODUCT(($A$4:$A$13=$A20)*($B$4:$B$13=B$19)*COUNTIF($D$17,Data[[#Headers],[31-03-2021]:[30-09-2021]])*$C$4:$I$13)

It works fine & thanks for new solution...

Though I have marked as solved query

I am requesting you for following question
How I can get summation of selected fields i.e. Cash, Travel, Driver for the date 30-04-2021 from this table without emp ID

**sanjuss2** · 10-27-2021, 12:52 PM

Thanks Bo_Ry your formula solved my request query too.....

Select data on basis multiple vertical criteria

LinkBack

Thread Tools

Rate This Thread

Display

Select data on basis multiple vertical criteria

Re: Select data on basis multiple vertical criteria

Re: Select data on basis multiple vertical criteria

Re: Select data on basis multiple vertical criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to delete the entire row basis multiple criteria

Index and Match for multiple criteria with vertical and horizontal data source

[SOLVED] extract data from list on the basis of multiple criteria

Choose data horizontal and vertical, multiple criteria

[SOLVED] How to sum on the basis of Multiple Criteria by using SUMIFS

[SOLVED] Summing Data with Multiple Criteria on Horizontal and Vertical Axis'

[SOLVED] Matching multiple criteria in two books, one data is horizontal, the other is vertical.

Bookmarks

Bookmarks

Posting Permissions