Formula to add number of pallets shipped

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to add number of pallets shipped

08-13-2012, 06:40 AM

Catalin.B

Windows Vista Formula to add number of pallets shipped

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:05 PM.