Hi Everyone,
I have a following data set
<tbody>
</tbody>
I am looking for a formula which would return the value as per the following table criteria.
<tbody>
</tbody>
Thank you so much in advance.
Regards
Shib
I have a following data set
Date | Dealer Type | State Name | Sale Value |
01-05-2017 | Registered | Tamil Nadu | 3,483.00 |
01-05-2017 | Un-Registered | Uttar Pradesh | 2,591.00 |
01-05-2017 | Un-Registered | Maharastra | 3,530.00 |
01-05-2017 | Un-Registered | JAMMU AND KASHMIR | 1,982.00 |
02-05-2017 | Un-Registered | HIMACHAL PRADESH | 4,599.00 |
03-05-2017 | Un-Registered | PUNJAB | 4,380.00 |
05-05-2017 | Un-Registered | CHANDIGARH | 1,238.00 |
02-05-2017 | Registered | UTTARAKHAND | 949.00 |
03-05-2017 | Registered | HARYANA | 2,774.00 |
05-05-2017 | Registered | DELHI | 4,975.00 |
02-05-2017 | Registered | RAJASTHAN | 4,766.00 |
03-05-2017 | Un-Registered | UTTAR PRADESH | 4,651.00 |
05-05-2017 | Registered | BIHAR | 1,218.00 |
02-05-2017 | Registered | SIKKIM | 4,689.00 |
03-05-2017 | Un-Registered | ARUNACHAL PRADESH | 1,168.00 |
05-05-2017 | Registered | NAGALAND | 3,328.00 |
02-05-2017 | Registered | MANIPUR | 821.00 |
03-05-2017 | Un-Registered | MIZORAM | 1,698.00 |
52,840.00 |
<tbody>
</tbody>
I am looking for a formula which would return the value as per the following table criteria.
Date | Total Sale | Uttar Pradesh | Tamil Nadu | Rest of India |
01-05-2017 | 11,586.00 | |||
02-05-2017 | 15,824.00 | |||
03-05-2017 | 14,671.00 | |||
05-05-2017 | 10,759.00 | |||
52,840.00 | - |
<tbody>
</tbody>
Thank you so much in advance.
Regards
Shib
Last edited: