I’m attempting to use the SUMIF function to sum the total of numbers in column B based on the values in column A. The values in column A could be either numbers or letters. If a cell is not blank in column A I’m looking for the corrosponding number in column B to be summed.
Tried using wildcards as the Criteria in the SUMIF formula but to no avail. Also tried playing with ISBLANK=0, couldnt get that to work either.