#1
|
|||
|
|||
Formula to add number of pallets shipped
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?
|
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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
|
Tags |
count, formula, sum |
|
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 |