thank you
Can i ask is there anywhere to get good information on how the sumproduct works.
I dont have a clue what the difference between ur 2 answers are since they both work ou tto be the same answer
I need to do another sumproduct now and still lost.
Sumproduct is very new to me and im still trying to learn how they actually work.
Here is my next issue
Column F is my Client listing
Column P Is the call type
Column I is the call duration
I need to work calculate the total duration of call time from this data for each client and each call type
So if F equals "BPS" and P equals "General" then add the value in columb I
Bookmarks