Help with Formula

Ragincajun22 · #1 08-24-2017, 06:49 AM

So I have cell B2 That is the abbreviation of a month, and cells c3:G3 are months June-oct. Row 4-60 are item numbers and c4:G4 are delivery amounts. I am trying to sum from the current b2 back to C. To show all delayed shipments. So if cell b2 is sept sum c4:f4, or if b2=Oct, sum G4:C4. Please help.

xor · #2 08-24-2017, 08:44 AM

=sum($c$4:index($c4:$g4,match($b$2,$c3:$g3,0)))

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
IF + AND formula help	david_89_	Excel	4	06-11-2014 11:07 AM
Need help with a formula	e_a_g_l_e_p_i	Excel	14	02-07-2013 12:37 AM
formula help	excelledsoftware	Excel	8	03-25-2012 08:49 AM