=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![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
=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.
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
I am not very technically advanced in Excel, so I would appreciate as much detail as possible.
Thanks in advance,
Jack
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)