Share via

What function do i need

Anonymous
2024-07-31T21:13:49+00:00

I want to calculate all the money that appears on the right to be calculated on the left.

So all of the amounts under 152 on the right to be total on the left?

Please & Thank you in advance!

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-07-31T22:55:39+00:00

    Hi,

    You may also use a Pivot Table.

    Was this answer helpful?

    0 comments
  2. HansV 462.6K Reputation points
    2024-07-31T22:05:50+00:00

    In C2:

    =SUMIFS(I:I, H:H, B2)

    Fill down. If you have Microsoft 365, you can also use

    =SUMIFS(I:I, H:H. B2:B43)

    This will spill to C2:C43.

    Was this answer helpful?

    0 comments