var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Countif & Sumif with no match
I have a column of data (numbers) from this colum I want to count the numbers that do not appear in the second column. I then need to sum the value in the adjecent column.
Can anybody help? I am tearing my hair out.
Use a VLOOKUP to determine if the value exists in the second column. Use that as criteria for your SUMIF statement.
ProTip: VLOOKUP returns the error condition #N/A when false. ISERROR() can be used to trap #N/A