I used to know how to do this! Last month, actually. But my brain has dropped something from the formula.
So as to not confuse anyone with my dysfunctional function, here's what I am trying to do:
If B5 is greater than 0 and G5 = "X" or H5 = "X" then L5, if not, 0
(or by column titles) If in column "NAME" there is a name, and either column "CHILD OVER 6," or in column "CHILD UNDER 6," has been marked, then the information in column "HOME VISITS" needs to be used; if not, enter 0
Bookmarks