Help with Formula
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.
|