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
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