Formula to add number of pallets shipped

piglovindillard · #1 08-10-2012, 03:18 PM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help with a look up or if formula	beb1227	Excel	3	12-31-2011 01:08 PM
Mailing: how to make the "page number" in Word is the same as "row number" in excel w	Jamal NUMAN	Word	1	09-03-2011 11:37 AM
Office 2007 Professional shipped from US, will it work on UK Windows PC's ?	OfficeDude	Office	3	08-16-2009 02:11 PM
Help for formula	dehann	Excel	5	05-01-2009 10:44 AM
Need help with a formula	tinkertron	Excel	11	04-16-2009 11:43 PM