Column A matches, then Sum that row and multiply by end value

[Tom1010]

Have been doing this manually, but finding it very time consuming and want to know if it's possible to do what I'm hoping to achieve...

Here is a very simplified version of the spreadsheet I am working off and for a multitude of reasons I have to keep it set up in this format. I'm hoping to calculate all the totals paid to different companies in each financial year but also have annual total records.

What I want to do is for cell B9 for example, search column A, if company A, then sum the total in each row where A is listed up until June and then multiply the total of that row by the cost per unit figure in column K.

Any help would be great!

[JohnTopley]

Attach a sample workbook(not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Tom1010]

Thanks John

[FlameRetired]

Try this.

=SUMPRODUCT((RIGHT(A12,1)=$A$2:$A$9)*($B$2:$B$9:INDEX($B$2:$J$9,,MATCH("JUNE",$B$1:$J$1,0)))*$K$2:$K$9)

[JohnTopley]

Dave has given you the formula.

In your image you indicated that there was data for more than one year: if so, use Excel data (01/06/2017) for June 2017 to identify the year.

And of course the formula would need to be modified.