hello
I m trying to count occurrences based on values of three cells
on single Cell it works :
Formula:
Please Login or Register to view this content.
but on multiple ones it doesn`t work, I tried this
Formula:Please Login or Register to view this content.
Can you help please ?
Thanks
=SUM(COUNTIF(A$1:A2,D2:F2)) Try this array formula (Shift+Ctrl+Enter)
or
=SUM(INDEX(COUNTIF(A$1:A2,D2:F2),0))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Or
Add a sumproduct in front of Countif()
=SUMPRODUCT(COUNTIF(A$1:A2,D2:F2))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
it need to give this resultsOriginally Posted by nflsales
it is double counting I thinkHTML Code:
this one double counting too
Last edited by bimo; 12-15-2014 at 07:53 AM.
Attach sample sheet
here it is..Thanks
D2=COUNTIFS(A$2:A2,A2,B$2:B2,B2,C$2:C2,C2)
and copy towards down
You haven't told us what you want... The cell references in your sheet do not match those in Post 1. Some of the values have extra spaces after them, which I have removed. is this what you were wanting to achiee? If not please show what your expected result should look like.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Applogies, I have taken the spaces out..Results I am trying to achive is on Column D,
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks