#### jwgreen1986

##### Board Regular

- Joined
- Mar 8, 2019

- Messages
- 64

basically i want to do a formula where if the values of two cells dont match something then sum 3 cells to give a total.

in one column i have account. and in the other i have department.

i want the formula to look in this and when the account is not equal to gross profit AND department is not equal to USED VEHICLES then add up 3 different cells to give a total.

the important part is the AND. i want other accounts of used vehicles to be calculated (units and F&I) but i do not want it to add any where the department and account equals gross profit and used vehicles.

similarly i want other departments of gross profits to be calculated (new vehicles etc)

so basically i want 3 cells adding up if the account cell AND department cell do not equal gross profit and used vehicles. it has to be both and not just one or the other.