# Formula work when i use Subtotal(5, but wont work when i use Min. Y? WHats the difference?

1. ## Formula work when i use Subtotal(5, but wont work when i use Min. Y? WHats the difference?

I have a sample data attached. I use formula to count the no of times each column appear as the smallest with its row. Example A1:C1.

I manage to get the formula in A8:C8 using sumproduct and subtotal. However, i tried to change the subtotal to Min and it wont work. Why is it so? Aint they suppose to be the same????

2. ## Re: Formula work when i use Subtotal(5, but wont work when i use Min. Y? WHats the differe

Sorry, I really dont understand what that formula is supposed to be doing?
=SUMPRODUCT(--(A1:A6=SUBTOTAL(5,OFFSET(\$A\$1,ROW(A1:A6)-ROW(A1),,1,3))))
What does 2 (or 1 or 3) represent?

3. ## Re: Formula work when i use Subtotal(5, but wont work when i use Min. Y? WHats the differe

Hi, its suppose to count how many times the column is the MIN within the row of 3. I have put conditional formatting to highlight the Lowest within the Row (example, A1 has value of 104 and is the min in A1:C1.
Hence the 2 you see in A8 is A1 and A6 where they are the min. The 1 in B8 come from B2. The 3 in C8 come from C3, C4 and C5.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1