I currenty use sumproduct function
i got 3 column which contain data
in my sumproduct, i need to know the total of specific item on spesific condition
example
if i select item in column 1 plus specific item in column 2, it will calculate the total of the condition i select
my problem is, i want to select column 1 but dont want to select column 2 that will give the result of the sumproduct of column 1
but it give me error (#value)
attach is my example
thanks
abu
Bookmarks