clarification on countif

  • Thread starter Thread starter T.N.
  • Start date Start date
T

T.N.

Clarification:

I have a system where I have values In A2 through D2.
Underneath A2 through D2 is a four column by 20 row box.

The value is A1 is the formula of this. If you find a 1
in the box, refer to its corresponding value in row 2.
Add up all the occurrences of 1, but not with 1, instead
with it's corresponding value in row 2. Is that clear? I
hope so.

A1
$100 $200 $300 $400
1
1
1
1

So A1=$100+$100+$200+$300

I am going to do this same thing for B1 and 2, and C1 and
3, and D1 and 4 and so on. But I figure once I get the
formula for A1 I'll be fine. I'm still having problems
with the COUNTIF function.

THANK YOU!!!!!
 
A SumProduct formula with the star syntax would do what you want:

=SUMPRODUCT(($A$2:$D$2)*($A$3:$D$22=1))
 
Back
Top