hi there
i'm trying to fix a spreadsheet that's converted from lotsu 1-2-3 to excel
basically, i need to take any value in (for example) column C and sum them, but only if the corresponding cell in column A contains the number 1... if you follow?
it seems i can do this using DSUM, but i cannot get it to work
i'm trying to fix a spreadsheet that's converted from lotsu 1-2-3 to excel
basically, i need to take any value in (for example) column C and sum them, but only if the corresponding cell in column A contains the number 1... if you follow?
it seems i can do this using DSUM, but i cannot get it to work