Categories
User Help Web Apps

Count mismatches between rows in google sheet

Need some help on this cause I’m getting an issue I’ve this three columns (Time, R1 and R2) and I’m trying to count the mismatches between R1 and R2 but for each month (on the time column) I already used a formula but I’m having an issue to add 1. =iferror(if(EOMONTH($A64,0)=$A64,SUMPRODUCT(month(Database!$C$2:$C) = month($A64),–(Database!G$2:G <> Database!H$2:H)),””),”Error”) […]