Countifs formula to count noumber of rows where Total does not match the sub components

[Ajay_Gunware]

hi All,

i am trying to count the number of rows where the total does not match with the sub-components. i have to do this without adding any new row.

Weekly Monday Tuesday
100 10 90
80 10 70
100 30 100

here weekly should be sum of monday and tuesday, i want to count the number of rows where weekly is not the sum of monday and tuesday.

can anyone help please.
many thanks and regards,
Ajay Gunware

 

[Special-K99]

Surely you want to know what rows are incorrect?
If you have 17 rows out of 50 that are incorrect you're not bothered which ones they are, just that there are 17 incorrect?

 

[Ajay_Gunware]

yes.... just a count of where total does not match the sub-components.
in short .. what you said. exactly.

 

[BGY23]

I know you can't add a new ROW but can you add/ use another column?

If so =if(weekly-sum(Mon:Tues)<>0,1,0

and sum that column

 

[Special-K99]

I know you can't add a new ROW but can you add/ use another column?

If so =if(weekly-sum(Mon:Tues)<>0,1,0

and sum that column

That's the only way I can see of doing it at present.