• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMPRODUCT variable?

rbobcat1

rbobcat1

Member
Is there sometimes something wrong with using D as a variable?


The formula works great for other letters I'm using except D


I even used find and replace to replace all of the D's to DD or Team D and it found and replaced 36 D's.

Then of course adjust the formula but then the formula only finds 6.

I even thought that maybe a space before or after might be an issue so I did a copy and paste to all 36 cells to no avail


=SUMPRODUCT((F2:F144="D")+SUMPRODUCT(M2:M144="D"))
 
Hi ,


The way your parentheses are placed , did you mean :


=SUMPRODUCT((F2:F144="D")+(M2:M144="D"))


What exactly do you want to get from this formula ?


Narayan
 
Even with Narayank's correction, I'm not sure what the formula is trying to do. If you're just counting the number of D's, formula would be:

=COUNTIF(F2:F144,"D")+COUNTIF(M2:M144,"D")


If you're wanting to know how many rows have a "D" in col F and col M, formula is:

=SUMPRODUCT((F2:F144="D")*(M2:M144="D"))
 
sorry, i am using it to count the "D" or whatever letter or letters


from the sounds of the post i would be better off using countif
 
You must log in or register to reply here.
Back
Top