In the spreadsheet I have in one column the amount of pallets intended to ship and then a total at the bottom that's just a simple sum formula. In the next column I put a check (by typing "P" formatted in wingdings 2 font) if it ships. I want to be able to have a total of shipped pallets automatically come up. Right now I have a count formula that tells me how many "P"s are in the column but that is only accurate if it was only one pallet. How could I do this?

You could probably use a COUNTIF or SUMIF formula, but it's difficult to say for sure without seeing the worksheet.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul is right, SUMIF is a good option for you: =SUMIF(B1:B8;"P";A1:A8), where B1:B8 is the criteria range, and A1:A8 is the range to sum