Forum Discussion
Need help with a formula
Hi,
I'm struggling with one issue: I have several columns: B: cities; C: latitude; D: longitude, G: a number of companies. If I have the same value in C3:C4, D3:D4, then I want a total of G3:G4 in the column H, so I can get rid of the duplicates later. it is a file with more than 2000 rows...
- I came across this with no reply.
if still interested, try:
IN COLUMN H:
=IF(AND(C3=C4,D3=D4),SUM(G3:G4),"")
copy down
try this in a separate test worksheet.
always back-up your work.
Hope This Helps.
thanks..
