Hello -
I'm trying to write a SUMIF formula based on the criteria that my column starts with a certain character. My formula seems to work if the column I'm basing it off of is text, but it does not work for numeric values which is my problem.
Below is a table I have my in spreadsheet showing Sales Location ID in column B and Product Sales in column C. (This information is in a pivot table so I don't believe I can change the values or their format.) Below is my formula:
=SUMIF($B$6:$B$19,"1*",$C$6:$C$19)
If the "1*" was text (let's say "A*" and my values in column B started with letters, sometimes A), the formula would work. But I cannot get it work with the numeric values below. Is this possible to do? I tried using the TEXT function within my formula but haven't had any luck either, but perhaps I just have the syntax wrong?
I'm trying to write a SUMIF formula based on the criteria that my column starts with a certain character. My formula seems to work if the column I'm basing it off of is text, but it does not work for numeric values which is my problem.
Below is a table I have my in spreadsheet showing Sales Location ID in column B and Product Sales in column C. (This information is in a pivot table so I don't believe I can change the values or their format.) Below is my formula:
=SUMIF($B$6:$B$19,"1*",$C$6:$C$19)
If the "1*" was text (let's say "A*" and my values in column B started with letters, sometimes A), the formula would work. But I cannot get it work with the numeric values below. Is this possible to do? I tried using the TEXT function within my formula but haven't had any luck either, but perhaps I just have the syntax wrong?
Sales Location ID | Product Sales |
0 | 0.00 |
100 | 1,546,559.62 |
200 | 763,188.86 |
300 | 107,983.83 |
400 | 601,535.34 |
500 | 587,383.30 |
600 | 701,949.58 |
700 | 168,568.16 |
4,477,168.69 | |
112 | (350.00) |
117 | 11,045.20 |
315 | 368.38 |
316 | (6.41) |
320 | (750.00) |
10,307.17 | |
4,487,475.86 |