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
 

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

Top