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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.