• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count number

stormania

stormania

Member
Dear Excell Master

Hi...i have a file (attach) that i want to calculate count number as a sheet REPORT and data base in STO GR sheet, that i want to summary how many number 1, 2, 3, etc per column (GR-GI, GI-DN, STO-DN).
Kindly help.

Thank in advance
 

Attachments

  • COUNT PLANT.xls
    477.5 KB · Views: 11
@stormania

LOOKUP is used because you merged your first row, and it will return the last cell with text as you dragged the formula across. Basically when you merge cells than only first cell has text rest are blanks. For Eg. If A1 has Boy and you merge A1:C1, so B1 & C1 will be blank. Lookup will look zzzz which is a big string and when not found will return the last string which is Boy, when you drag this formula to B1 than also boy and C1 also Boy, but if D1 is Girl it will return Girl when you copy the formula from D onward.

-- is used to convert TRUE / FALSE to 1 & 0 respectively. The same can also be achieved by adding +0 to it.

Regards,
 
You must log in or register to reply here.
Back
Top