if you need the number of "Type A" occurences then why not try:

=COUNTIF(A1:A380000,"Type A")

if you need to arrive at a sum of A1:A380000 when there "Type A" in
column B, try:

=SUM(IF(B1:B380000="Type A",A1:A380000,))
CTRL+SHIFT+ENTER it instead of simply using ENTER