Hello,
I am trying to combine the SUMIFs and LEFT functions to sum data based upon two separate criteria.
Column B Column C Column Z
1. 10001 4001 1,000,000
2. 10001 4004 1,000,000
3. 52001 4099 5,000,000
4. 62001 4512 6,000,000
I am trying to return a sum of Column Z if Column B = 10001 and if LEFT Column C = 40. In this case, I should return a value of $2,000,000 for rows 1 and 2. The following formula is what I'm trying to use:
=SUMIFS(Z1:Z4, C1:C4, LEFT(C1:C4, 2)="40", B1:B4, B1:B4="10001").
The formula is returning a value of 0. I've tried using a SUMPRODUCT formula and a SUM/IF array combination without any success and I'm out of ideas. Any help is greatly appreciated! Thank you very much in advance.
Bookmarks