Adding Up all Row totals when one cell contains A or B

[fayec]

Hi,
Hope your all well? Please see the attached, we have cargo coming in from Area L and Area B. I would like to figure out each month how much comes from each area. Then if possible do the same again but instead of all units its just the timber units?
Many Thanks in advance
Regards
Faye

[TMS]

Do you mean like this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[fayec]

Hi,
Thank you the bottom one worked fantastic. Now if I wanted to do all cargo do I just change the sum from D3:K15? Many Thanks Faye

[AliGW]

No - you'd need SUMPRODUCT. Try:

=SUMPRODUCT(('Cargo 2023'!C3:C15="L")*'Cargo 2023'!D3:K15)

[fayec]

Thank you, I just need to figure out how to use the formula and add the sheet name I need the details from, if that makes sense?
Thank you
Faye

[AliGW]

Replace Cargo 2023 with the sheet name of the sheet containing the data.

If you can't work it out, attach a workbook.

If you mean by row and column, does this help?

=SUMPRODUCT($D$3:$K$15,($C$3:$C$15="L")*($D$2:$K$2="Pulp"))

[fayec]

Thank you, I've tried to add in the sheet but keep getting an error message. So on my Lake vs Baltic I need to figure out from the Cargo sheet the total number of Lake vessels, then the total number of Baltic vessels. Then in the months figure out the total amount of Timber from each area. I've attached the spreadsheet I'm working on. Many Thanks again for all your help, I'm learning new things all the time. Thanks Faye

[AliGW]

B6:

=SUMPRODUCT('Cargo 2023'!$D$3:$K$15,('Cargo 2023'!$C$3:$C$15="L")*('Cargo 2023'!$D$2:$K$2="Timber"))

C6

=SUMPRODUCT(('Cargo 2023'!$D$3:$K$15<>"")*('Cargo 2023'!$C$3:$C$15="L")*'Cargo 2023'!$D$3:$K$15)

Adapt for other months and commodities.

[fayec]

Thank you thats perfect. Have a lovely day

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.