I have values in rows which am going to use to calculate efforts as given below:
day1 day2 day3 day4 day5
7 L 7 7 7
7 7 L L 7
L L 7 7 7
(L=Leave)
While calculating the sum for the above rows i want to assign L= -7 and get sum. Can any one suggest easy way to do this?
Hello
for all the table above something like
=SUM(A1:E3,COUNTIF(A1:E3,"L")*-7)
or row by row
=SUM(A1:E1,COUNTIF(A1:E1,"L")*-7) then fill down
the logic is to sum the numbers 7 -->sum(A1:E1,
then count the number of letter L then multiply by negative 7 COUNTIF(A1:E3,"L")*-7
Hth.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks