Gladys wrote:
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.


I think you can use SUMIF function. Check the online help.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy