I am hoping someone may be able to help me with a formula. I am attaching a little example of what I am looking for. I would like a formula in cell G2 that will add any of the contents in the range of cells B3 to B5 IF any of the cells in the range of cells A3 - A5 are "Prenatla Screening".
I have been playing around trying to create this formula but am having no luck at all. I am in over my head.
Anyone help is most apprecated! Thanks so much in advance.
Bookmarks