Microsoft Office Forums - View Single Post - [Solved] Formula to add number of pallets shipped

Thread: [Solved] Formula to add number of pallets shipped

View Single Post

Old

08-13-2012, 06:40 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

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

Reply With Quote