Round two- Excel help

[revolution]

Do you want to always keep one of the columns in your formula absolute and not change it? So if you wanted to always look at A9, you can change the A9 in the formula to be $A$9.

[NothingWrongwithOhio]

List your clients and then use SUMIF.

I can post an example if you give me a few minutes.

[NothingWrongwithOhio]

Nvm, I was wrong, can't do multiple columns as the requirement or the range that way.

Maybe this is an asshole question, but why are they on separate sheets? Why not put all the data on one sheet (with a month or date column) and then you could make a pivot table and it would be easy to get info?

[5hole]

Sumif works as an array in this scenario. What version of excel do you have?

[JayhawkGirl]

I'm admittedly half awake, but I think VLookup will do what you want. Basically VLookup go find this data (name) over here (other tab, other area of data) and return the data point found in column #.

[bearbaby]

Yup, you have to use a vlookup within the if/then statement.

ETA: It's probably hard to "describe" writing the formula.  I love Excel stuff - if you have dummy data and want to PM I can write it for you.  That might be creepy, so take it or leave it   I'm just an Excel nerd.

[trafficgirl]

I agree with bearbaby - you need a nested vlookup function in the if/then function. Unfortunately I'm not super great with those. I would need the spreadsheet to try and figure it out - not saying you should sent it to me!