Array Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create two array formulas. The first looks at an array and if any value in the array is 1 (and there can only be at most one such value) then it identifies the value in the adjacent column. For example if in column A I have the following data beginning in row 1: 0,0,0,1,2. The formula would return the value in B4.

The other array formula looks at an array and if all values are zero it then returns zero and if not it sums another array. Thank you.
 
Hi
for the first question use:
=VLOOKUP(1,A1:B100,2,0)
(a non array formula)

For the second question use
=IF(COUNTIF(A1:A100,"<>0")>0,SUM(B1:B100),0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simply Array Formula? 5
How to use vlookup in an array formula 2
Excel Wildcard in Excel array formula 0
Array follow up 1
MAX / MIN function problem 4
Lookup based on matrix values 2
Summary of data using array formula 1
making sure a cell in an array is not duplicated 2

Back
Top