Hi I have a data set and want to calculate the total "Sales" and "Purchase" Reps total through countifs formula.
Hi I have a data set and want to calculate the total "Sales" and "Purchase" Reps total through countifs formula.
Hi there. Like this, maybe...
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
countif will return the number of sales lines
Formula:Please Login or Register to view this content.
which is 5
are you sure you dont want sumif?
like
Formula:Please Login or Register to view this content.
which is 17?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks glenn
thanks humdingaling.. sumif is what I wanted.
You're welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks