sumif be by categories

[howard]

I have description in Col A. I need a sumif formula or another formula to sum the data where I have summarised the descriptions into categories


See sample data below


It would be appreciated if someone could assist me

Book1
	A	B
1	COS Shirts Used	1595
2	COS Tracking Used	2584
3	O/all PRF Used	956
4	O/all PHJ Used	1478
5
6
7
8	Category Summary
9	COS
10	O/all
11
Sheet1

 

[Peter_SSs]

Is this what you need, copied down?

Excel Workbook
	A	B
1	COS Shirts Used	1595
2	COS Tracking Used	2584
3	O/all PRF Used	956
4	O/all PHJ Used	1478
5
6
7
8	Category Summary
9	COS	4179
10	O/all	2434
SUMIF

 

[howard]

thanks Peter. This is perfect. I was not sure how to incorporate the wild card character into the criteria. with your assistance, I now now

 

[howard]

Hi Peter

I have another query pertaining to Sumif to add anything that contains Sales and Int in Col b for eg Sales Internal Labour, Sales Int etc, where sales and Int or Sales Internal appears in the text in Col B


your assistance in resolving this is most appreciated




See sample data below. I have several other categories, but once I have resolved this one, then I should be able to do the others as well

Book1
	A	B
1	Sale Lab Internal	14,846
2	Sale Lab Internal	3,276
3	Sale S/let Internal	2,007
4	Sale Oils/Other Int	478
5	Sale Consumables Int	37
6
7
8
9	Sale Int	0
10
Sheet1

Cell Formulas
Range	Formula
B9	=SUMIF(A1:A5,A9&"*",B1:B8)

 

[Jborg]

Nice one Pete. Just Beautiful!!!

 

[Peter_SSs]

.. anything that contains Sales and Int ..

Assuming that the Sale & Int come in the order shown in cell A9 ..

Excel Workbook
	A	B
1	Sale Lab Internal	14,846
2	Sale Lab Internal	3,276
3	Sale S/let Internal	2,007
4	Sale Oils/Other Int	478
5	Sale Consumables Int	37
6
7
8
9	Sale Int	20644
SUMIF

Nice one Pete. Just Beautiful!!!

Hi John, hope things are well with you. Good to hear from you.

 

[howard]

Thanks Peter-magic formula. It works perfectly