Hi
I am working a spread sheet for work. This is NOT homework and this is not part of the duties I get paid for. Like the title says. I need to Count the number of text string Occurence if the Value in another Column is "Adair" (as an example) This is what I cam up with and it is not working. Can someone please help?
=PRODUCT(--(January!L3:L900="Adair"),(COUNTIF(January!G3:G902, "Active / Change")))
Thank you
tish
Bookmarks