I need to perform a SUMIFS function with a LEFT function nested. Here is an example of my data:



SUMIFS($P:$P, $G:$G, $A1, $H:$H, "Composite")

P = Total Assets
G = Account Number
H = Class Identifier
A1 = First Digit of 16 digit account number to create 'buckets'

I thought the formula would be like this:

SUMIFS($P:$P, LEFT($G:$G,1), $A1, $H:$H, "Composite")

The LEFT function should always return the 1st digit of the account number, then look at A1 to see if that matches, then sumifs of all the assets in each bucket (6 in total).

But that is not working. Any suggestions are super appreciated!!