In each row I have 6 values, either an A or an R. I have 19 rows. In each row I want to count "A" and square it, and add that to the count of R squared. I can do it row by row (see column H attached) but want to be able to come up with the final sum (418) directly. Every countif and Sumproduct I've tried doesn't come close.
Last edited by ChemistB; 10-08-2015 at 04:08 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
with this udf maybe
Kind regards
Please Login or Register to view this content.
Leo
Try this...
=SUM(MMULT(--(A2:F20="A"),{1;1;1;1;1;1})^2)+SUM(MMULT(--(A2:F20="R"),{1;1;1;1;1;1})^2)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks to both of you. Both excellent suggestions.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks