Sum a column if.. (1 Viewer)

bunji

Registered User.
Local time
Today, 15:52
Joined
Apr 26, 2005
Messages
124
I would like to move sum A1:A6 If the B cell is = True and another cell is = 1.

I have an attachment that shows the layout.

Therefore Total = 76.7

Does that make sense? If so how could i work out the formula?
 

Attachments

  • example.txt
    89 bytes · Views: 333

bunji

Registered User.
Local time
Today, 15:52
Joined
Apr 26, 2005
Messages
124
i have =SUMIF(B1:B6,TRUE,A1:A6)

But how do i add the second criteria
 

bunji

Registered User.
Local time
Today, 15:52
Joined
Apr 26, 2005
Messages
124
Ok i did it using an array

=SUM((B1:B6=True)*(C1:C6=1)*A1:A6)

To Enter the array press Ctrl Shift Enter when leaving the cell.

Hope this helps anyone who came across the same problem.
 

Users who are viewing this thread

Top Bottom