Need lookup formula with sum condition

[Kulo5856]

Dear Experts,

I need formula for the below

Machine Name	JCB-1	JCB-2	Scooter-1	Scooter-2
Date	Day	Fuel Type	Issued	Fuel Type	Issued	Fuel Type	Issued	Fuel Type	Issued
01-07-2023​	Saturday	Diesel	5​	Diesel	20​	Petrol	5​	Petrol	10​
02-07-2023​	Sunday	Diesel	25​	Diesel	10​	Petrol	5​	Petrol	10​
03-07-2023​	Monday	Diesel	30​	Diesel	2​	Eng oil	1​	Eng oil	1​
03-07-2023​	Monday	Hyd Oil	1​	hyd oil	1​	Petrol	2​	Petrol	15​

Fuel type	Pre Bal	Received	Total Issued	Closing Balance
Diesel
Petrol
Eng Oil
Hyd Oil

For this Total no of Issued Qty needed from the data for Fuel Types

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Machine Name	JCB-1	JCB-2	Scooter-1	Scooter-2
2	Date	Day	Fuel Type	Issued	Fuel Type	Issued	Fuel Type	Issued	Fuel Type	Issued
3	07/01/2023	Saturday	Diesel	5	Diesel	20	Petrol	5	Petrol	10
4	07/02/2023	Sunday	Diesel	25	Diesel	10	Petrol	5	Petrol	10
5	07/03/2023	Monday	Diesel	30	Diesel	2	Eng oil	1	Eng oil	1
6	07/03/2023	Monday	Hyd Oil	1	hyd oil	1	Petrol	2	Petrol	15
7
8	Fuel type	Pre Bal	Received	Total Issued	Closing Balance
9	Diesel			92
10	Petrol			47
11	Eng Oil			2
12	Hyd Oil			2
Sheet4

Cell Formulas
Range	Formula
D9:D12	D9	=SUMIFS($D$3:$J$6,$C$3:$I$6,A9)

 

[Kulo5856]

Thanks for that but if we have any additional columns that lookup formula is required

Machine Name

JCB-1

JCB-2

Scooter-1

Scooter-2

Date

Day

Fuel Type

Pre Bal

Issued

Closing Bal

Fuel Type

Pre Bal

Issued

Closing Bal

Fuel Type

Pre Bal

Issued

Closing Bal

Fuel Type

Pre Bal

Issued

Closing Bal

01-07-2023​

Saturday

Diesel

1​

5​

Diesel

5​

20​

Petrol

1​

5​

Petrol

5​

10​

02-07-2023​

Sunday

Diesel

2​

25​

Diesel

2​

10​

Petrol

2​

5​

Petrol

5​

10​

03-07-2023​

Monday

Diesel

1​

30​

Diesel

1​

2​

Eng oil

1​

Eng oil

1​

03-07-2023​

Monday

Hyd Oil

1​

hyd oil

1​

Petrol

1​

2​

Petrol

3​

15​

for this data i want the formula

Fuel type	Pre Bal	Received	Total Issued	Closing Balance
Diesel
Petrol
Eng Oil
Hyd Oil

 

[Fluff]

How exactly is your data laid out?

 

[Kulo5856]

Sa.xlsx.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Machine Name		JCB-1		JCB-2		Scooter-1		Scooter-2			Fuel type	Pre Bal	Received	Total Issued	Closing Balance
2	Date	Day	Fuel Type	Issued	Fuel Type	Issued	Fuel Type	Issued	Fuel Type	Issued		Diesel
3	01-07-2023	Saturday	Diesel	5	Diesel	20	Petrol	5	Petrol	10		Petrol
4	02-07-2023	Sunday	Diesel	25	Diesel	10	Petrol	5	Petrol	10		Eng Oil
5	03-07-2023	Monday	Diesel	30	Diesel	2	Eng oil	1	Eng oil	1		Hyd Oil
6	03-07-2023	Monday	Hyd Oil	1	hyd oil	1	Petrol	2	Petrol	15
7
Sheet1

Cell Formulas
Range	Formula
B3:B6	B3	=TEXT(A3,"dddd")

 

[Fluff]

With that data you can use the formula I suggested.

 

[Kulo5856]

Sir please find the data below

Sa.xlsx.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	Machine Name		JCB-1				JCB-2				Scooter-1				Scooter-2					Fuel type	Pre Bal	Received	Total Issued	Closing Balance
2	Date	Day	Fuel Type	Pre Bal	Issued	Closing Bal	Fuel Type	Pre Bal	Issued	Closing Bal	Fuel Type	Pre Bal	Issued	Closing Bal	Fuel Type	Pre Bal	Issued	Closing Bal		Diesel
3	01-07-2023	Saturday	Diesel		5		Diesel		20		Petrol		5		Petrol		10			Petrol
4	02-07-2023	Sunday	Diesel		25		Diesel		10		Petrol		5		Petrol		10			Eng Oil
5	03-07-2023	Monday	Diesel		30		Diesel		2		Eng oil		1		Eng oil		1			Hyd Oil
6	03-07-2023	Monday	Hyd Oil		1		hyd oil		1		Petrol		2		Petrol		15
7
Sheet1

Cell Formulas
Range	Formula
B3:B6	B3	=TEXT(A3,"dddd")

 

[Fluff]

I asked you exactly how your data is laid out & you seem to be changing it. So once again EXACTLY how is your data laid out?

 

[Kulo5856]

the same posted recently as final data

 

[Fluff]

In that case you can use

=SUMIFS($E$3:$Q$6,$C$3:$O$6,T2)