drop down list and sum

		Microsoft Office Forums > Microsoft Excel > Excel
drop down list and sum

03-01-2018, 09:07 AM

p45cal

Windows 10 drop down list and sum

Office 2010 32bit

Expert

Join Date: Apr 2014

Posts: 956

Look in cells G7:H15 in the Copia de Material order sheet in the attached.
Formulae like:
=SUMIF($E$8:$E$28,G7,$C$8:$C$28)

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import list from Excel into drop-down list into word	ahw	Word VBA	43	02-28-2020 08:11 PM
Drop down list	emukiss10	Word VBA	0	11-20-2017 02:18 AM
Having a Drop-down list in Word referring to an Excel list	celias	Word VBA	3	07-11-2016 11:40 PM
Drop Down List Help	ksigcajun	Word	3	05-09-2014 05:35 AM
Drop down list, Can it be done???	garethreid	Outlook	0	08-09-2012 06:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:07 AM.