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)))

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