SUMIF with Match Index

[lorber123]

I need a sumif match index formula. On the Underwriting tab, row 3 shows the period. I need a sumif formula in cell B15 that will sum up the figures in column C of the Input page every time "Other Revenue" is seen in column B. Period 1 is currently column C, however, if I change C1 to a 0, then period 1 is now column D. If I then change D1 to zero then period 1 is column E. I need to be able to do a sumif on the Underwriting tab for each period which can change as more current data is added to the right in the Input Page.

The current example should show period 1 for Other Revenue as 105 in cell B15 of the Underwriting tab. If I change C1 in the Input page to 0, cell B15 in Underwriting tab would then show 210. I need it to be a sumif as there will be many more rows added.

I believe it is a mix of a sumif match index.

Please email with questions.

[José Augusto]

Try this in Underwriting!B15

Please Login or Register  to view this content.

and copy down and right

[José Augusto]

Sorry for las post. Try

Please Login or Register  to view this content.

[Pete_UK]

Put this formula in B15 of the Underwriting sheet:

=SUMIF('Underwriting Input Page'!$B$4:$B$21,$A15,INDEX('Underwriting Input Page'!$C$4:$Q$21,,MATCH(COLUMNS($B:B),'Underwriting Input Page'!$C$1:$Q$1,0)))

then copy across as far as you need to.

Hope this helps.

Pete