=SUMPRODUCT((August!I:I="No notes added")*(August!J:J="John Smith"))
=SUMPRODUCT((August!I:I="Notes added")*(August!J:J="John Smith"))
Hello,
I am trying to implement this formula into my spread sheet. I have multiple names which I need to count 1 if notes have been added or not for stats.
The formula works fine for about four names. However when I copy and paste and change the name to add more it doesn't seem to work and just displays 0.
Not a clue why it's not picking them up as it is working fine for the others.
I am not very technically advanced in Excel, so I would appreciate as much detail as possible.
Thanks in advance,
Jack
=SUMPRODUCT((August!I:I="Notes added")*(August!J:J="John Smith"))
Hello,
I am trying to implement this formula into my spread sheet. I have multiple names which I need to count 1 if notes have been added or not for stats.
The formula works fine for about four names. However when I copy and paste and change the name to add more it doesn't seem to work and just displays 0.

I am not very technically advanced in Excel, so I would appreciate as much detail as possible.
Thanks in advance,
Jack
