I want to sumup days by name and office
if it was only by name I could have done :
sumif(C:C;"sales";E:E)
but I need to add another condition for building too
I want to sumup days by name and office
if it was only by name I could have done :
sumif(C:C;"sales";E:E)
but I need to add another condition for building too
i just fount out that I can do sumproduct
Nice that you found the solution yourself Best way to learnOriginally Posted by mammut89
Don't forget that SUMPRODUCT does not accept full columns like C:C ( ratherc1:c65535) and that all ranges should be the same length.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks