Excel question

[Sir Tokyo Sexwale]

I'm trying to create a formula:

 

I have in Column C - account

Column G value in local currency

Col H location

 

I've created a SUMIF to say if account in col C = x, then give me the value in G [sUMIF(C:C,[account #],G:G)]

 

That's easy.

 

But how do I throw in an AND function, so I can get total both by account AND location at the same time?

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here