I can't get my sumif formula to pull the information I need and think i'm following what to do....

Brian R.

Here is the formula: I want a sum of revenue for each brand. Where range 2 is the Revenue column, range 1 is the brand column and sum range sums the first one correct?

=SUMIF({SEP - DEC 2024 Pending Assets Range 2}, {SEP - DEC 2024 Pending Assets Range 1}, [sum_range])

NicoLHC

@Brian R. are you referencing to another sheet?

=SUMIF({SEP - DEC 2024 Pending Assets Range 1}, "CEPRO", {SEP - DEC 2024 Pending Assets Range 2})

Brian R.

I figured it out!

NicoLHC

@Brian R. did my formula help you ? It seems you want to make summary across quarter ? In the current setup you need to. Add a quarters and build a new formula if I am correct I will cost you time . Maybe you want consider another way which is scalable.