Thanks, works perfect. I just changed the range you gave back to individual
cities as i need to know exactly where the sale was made in the total. And
the sales people move form city to city.

But works a charm.

Mint!

Nik

"Harlan Grove" wrote:

N|X6S|X wrote...
....
Basically i need to be able to know if a person has done a certain
thing, in a certain place. Column N-X are the people, and column
AC-AF are sales in certain cities. The columns N-X with 1's in them
are appointments for the person (eg N=nik O=emma etc.). Then in
column AC (eg AC=Auckland AD=Hamilton etc) if there is a 1 they have
made a sale from that appointment, if nothing, then no sale. . . .
....
Heres the hard part. That equation only covers N3 (nik, row 3) and
AC3 (row 3, making a sale in Auckland). But i also need it to
recognise Hamilton, and 2 other cities. Where i made another table,
replacing AC with AD for each. But the amount of formula/equations is
massively unecessary.. As it looks like this...

=IF(N3+AC3=2,1,0)+IF(N4+AC4=2,1,0)+IF(N5+AC5=2,1, 0)
....
IF(N100+AC100=2,1,0)+IF(N101+AC101=2,1,0)+IF(N102 +AC102=2,1,0)
....

For all 4 cities at once, use

=SUMPRODUCT(--(N3:N102+AC3:AF102=2))