You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:8e749c2ccac1a@uwe...
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