Array Formula (Sum with mult. criteria)

M

marksuza

Hi, I was wondering if I could get some help with an array formula tha
I cannot seem to crack.

=SUM((B3:B25="True")*(N3:N25="True")*G3:G25)

Column B are checkboxes and so is N . What I want to do is: If B and
are checked (true), sum the G column.

Thanks,

Marco
 
L

Leo Heuser

Hi Marcos

Drop the quotes, and it will run:

=SUM((B3:B25=True)*(N3:N25=True)*G3:G25)

In this situation you can use

=SUMPRODUCT((B3:B25=True)*(N3:N25=True)*G3:G25)

and just enter the formula with <Enter>
 
L

Leo Heuser

What checkboxes are we talking about?
Created with the Forms-bar (or similar) or the
Controls-bar (or similar)?
Have you defined the LinkedCell property
for each checkbox to point to the cell
"containing" the checkbox.
 
M

marksuza

The checkboxes were created with the form-bars and I am sure they ar
linked with the correct cells cause I am using them already. Thank
 
L

Leo Heuser

This is not being done automatically, when
you create the boxes.

Rightclick one of the boxes, choose "Format
control" (or similar), choose the tap "Control"
(or similar). The cells address, e.g. A3 must
be entered in the Linked cell box.

To get rid of the text TRUE or FALSE in the
cells, you can format the text with the same
colour as the cell (or have the linked cell in
another part of the sheet, and use that address
in the formulae)
 
M

marksuza

Sorry for the late reply. When I said I was using them I meant that
had already linked them. The formula did not work but I found a wa
around it. Thanks
 
Top