Would like to have APU 500 PARTS sheet L4:L30 to number 1,2,3,4 when K4:K30 is "Yes" have struggled with =MAX formula to make it work see attached sheet
Would like to have APU 500 PARTS sheet L4:L30 to number 1,2,3,4 when K4:K30 is "Yes" have struggled with =MAX formula to make it work see attached sheet
Hi,
Try this formula in L4 and pull it down using the lower right corner of the cell handle.
=COUNTIF(K$3:K4,"Yes")
Is that what you are looking for? The dollar sign in the formula counts down from the top cell.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
=IF(K4="No","",COUNTIF($K$4:K4,"Yes"))
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thanks added a little to it to cover blank cells as well now to work on the Summary page to create an order form
=IF(K4<>"",IF(K4="No","",COUNTIF($K$4:K4,"Yes")),"")
Last edited by jettechfsr; 12-26-2016 at 01:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks