You can get the total in P7 using this formula:
=LARGE(D7:O7,1)+LARGE(D7:O7,2)*(COUNTIF(D7:O7,"int")=0)
Copy down as required.
Hope this helps.
Pete
You can get the total in P7 using this formula:
=LARGE(D7:O7,1)+LARGE(D7:O7,2)*(COUNTIF(D7:O7,"int")=0)
Copy down as required.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks