Category Formula Help

[kiyo052]

Excel 2010

Is there a way to build a formula for E4, F4, E5, and F5?

My data is going to be in columns A, B, C. Is there a formula that would categorize the data into E and F? Please let me know! Thanks in advance!

	A	B	C	D	E	F	G
1
2
3	ID number	Options	Category
4	100	5x7	Rugs		Rugs	3
5	100	5x8	Rugs		Bed	2
6	100	5x9	Rugs
7	200	5x7	Rugs
8	200	5x8	Rugs
9	200	5x9	Rugs
10	300	5x7	Rugs
11	300	5x8	Rugs
12	300	5x9	Rugs
13	400	Queen	Bed
14	400	King	Bed
15	400	Twin	Bed
16	500	Full	Bed
17	500	King	Bed
18
29

<tbody>
</tbody>

 

[shyy]

Thanks for the explanation.

 

[markmzz]

Thanks for the explanation.

I'm glad to help.

Markmzz

 

[Aladin Akyurek]

Here is the image if anyone can't download the work book. Thanks again to all those who can help!

This reminds me of your earlier similar questions...

G8, just enter and copy down:

=COUNTIF(B3:B37,F8)

H8:

=SUM(IF(FREQUENCY(IF($A$3:$A$37<>"",IF($B$3:$B$37=F8,MATCH($A$3:$A$37,$A$3:$A$37,0))),ROW($A$3:$A$37)-ROW($A$3)+1),1))

which you must confirm with control+shift+enter, not just enter, and copy down.