Array Formula

[jmenche]

Howdy,

This not a VBA question but a complex array formula question.

Assume that I have values in C1:C10 and A1:A10. I want to write an array formula that would add up the values in row A only if the value in row C is 0. I am struggling with making the offset function dynamic.

:beerchug:

[Bob Phillips]

=SUMIF(C:C,0,A:A)

not even an array formula.

[jmenche]

Thanks xld but my uses for this are far more sinister. Ultimately, I want to use what is in row A in a vlookup so I was hoping for an array formula answer.

[Bob Phillips]

Then why don't you post the whole problem otherwise we are just guessing at what the solution might be.

[jmenche]

xld,

The attached file shows 2 examples of what I was trying to do. Ideally, I was trying to figure out how not to copy the formula in 15 different cells and then sum them up. This is a nice to know so don't knock yourself out on it.

Thanks for all of the help!:thumb

[Bob Phillips]

No file.

[Zack Barresse]

I've uploaded the file for you. Please do not email attachments to the admin email, just use the attachment manager in the reply post screen. :)

[mdmackillop]

Hi Jmenche,
You're going to have to explain what you're attempting to do.