Microsoft Office Forums - View Single Post - [Solved] Vlookup

Thread: [Solved] Vlookup

View Single Post

Old

03-02-2012, 11:47 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

SUMIF() should do the trick quite nicely.

=SUMIF(B2:B20,"Medical",C2:C20)

Reply With Quote