PERFECT, THANK YOU!

T. Valko wrote:
One way:

Entered in B2 then copied across to D2 then down to row 4:

=COUNTIF(INDEX($A$7:$C$9,,MATCH($A2,$A$6:$C$6,0)) ,B$1)

I cant seem to write an equation to solve the problem below. I can do it
manually by changing a countif formula, but would like it more automatic.
[quoted text clipped - 27 lines]
row
after that. Hopefully someone understands. Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200812/1