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:G...
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..
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..