Array Formula (Sum with mult. criteria)

  • Thread starter Thread starter marksuza
  • Start date Start date
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
 
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>
 
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.
 
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
 
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)
 
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
 
Back
Top