How would I write a formula that states if account number = 94411 add current
cost amount from Column "a" into a total instead of me manually selecting
which cells to add.

(A) (B) (C)
Current Projected Account
Cost Cost Number

$2,180.00 $2,180.00 94411
$10,414.98 $10,414.98 94411
$1,955.20 $2,045.00 94621
$918.23 $1,038.00 93703
$275.00 $275.00 94411
$200.00 $210.00 94411
$1,635.00 $1,635.00 93703
$135.00 $0.00 94411
$1,440.00 $1,440.00 94411

Thanks for all your help.