![]() This results in a sum of just the cells in row 2 that have a part number beginning with X. First, you could add the following into cell AL2: If you must use the SUMIF function for some reason, there are two ways you could approach the problem. This resulting value (1 or 0) is then multiplied by the individual cells in the data range. If it is equal, then the result is 1 if not equal then it is 0. The LEFT function returns the leftmost character of the part number and compares it to X. One way to accomplish this task is to use the SUMPRODUCT function along with the LEFT function to determine if the part number in the first row starts with an X or not: He wonders if there is a way to use SUMIF (or some other function) to sum the range B2:AK212 only for those columns in which the first cell in the column (B1:AK1) contains an "X" as the first character in the part number. Some part numbers begin with X and others begin with Y. George has a worksheet where the first row, in the range B1:AK1, contains part numbers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |