Smackalope
New Member
- Joined
- Mar 30, 2012
- Messages
- 7
I have a situation where I would like to count the number of cells in Column A that are equal to X if on the same Row, Column F has Y in it.
ie: If Row 1 Col A has X in it, and Row 1 Col F == Y in it, Count is 1.
ie: If Row 1 Col A has X in it, and Row 1 Col F <> Y, Count is 0.
ie: If Row 1 Col A has Q in it, and Row 1 Col F == Y, Count is 0.
Thanks for your help.
ie: If Row 1 Col A has X in it, and Row 1 Col F == Y in it, Count is 1.
ie: If Row 1 Col A has X in it, and Row 1 Col F <> Y, Count is 0.
ie: If Row 1 Col A has Q in it, and Row 1 Col F == Y, Count is 0.
Thanks for your help.