function

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

Guest

i am not sure how to do this. I have a narray of numbers
in colum a (a4:a121) of either 1 or 2. In colum f (f4:f121)
is the same array. I would like a formula that will look
across rows and compare i.e A4 and F6 and tell me if they
are both a number one. I would like to display the sum of
all the rows A AND F that display the number "1" only.
 
I am not sure what column your total is in that you want
to sum. I assumed you had a total on each row in column G
and here is a formula that might work for you:
=SUM(IF(AND(A4=1,AND(F4=1)),G4))
 
Back
Top