Hello!
I'm fairly new to excel and to this forum.
I'll just be straight about my problem
Here's a part of my data
A B C 1 1,2 1,4 2 1,3,4 2,3 1 1,4 2 1 3,4 2,3 2 1 1
So what i wanted to know is how do i get the number of data with A=1, B=4, C=2 so the result will be 2
So far, i've been using SUMPRODUCT to some of my data, apparently, it doesn't work when it comes to cells with "comma"
I tried using =sumproduct((A:A=1)*(B:B=4)(C:C=2))
it doesn't work because of the comma's
I need help
thanks!
Bookmarks