PDA

View Full Version : Array Formula



jmenche
03-12-2007, 07:22 AM
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
03-12-2007, 08:04 AM
=SUMIF(C:C,0,A:A)

not even an array formula.

jmenche
03-12-2007, 09:00 AM
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
03-12-2007, 10:57 AM
Then why don't you post the whole problem otherwise we are just guessing at what the solution might be.

jmenche
03-20-2007, 07:04 AM
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
03-20-2007, 11:56 AM
No file.

Zack Barresse
03-20-2007, 12:50 PM
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
03-20-2007, 01:37 PM
Hi Jmenche,
You're going to have to explain what you're attempting to do.