Go Back   Access World Forums > Members List

sundaram is on a distinguished road

sundaram sundaram is offline

Registered User

Visitor Messages

Showing Visitor Messages 1 to 2 of 2
  1. sundaram
    03-30-2016 11:14 PM
    I have the following data table. Please help me out with suitable countif formula.

    Ref: No Revision Item Grade
    D001 0 Civil D
    D001 1 Civil C
    D001 2 Civil B
    D001 3 Civil A
    D002 0 MEP-VE C
    D003 0 STR B
    D004 0 MEP-PL A
    D005 0 MEP-EL D
    D005 1 MEP-EL C
    D005 2 MEP-EL C
    D005 3 MEP-EL C
    D005 4 MEP-EL C
    D006 0 Civil B
    D007 0 MEP-DS B

    Here I want to count as below

    Total 7

    In abvoe 7 items the below should show the summary as
    It should check from C AND check IN columb B the greatest or if it is 0 and its related Grade to be taken to considered
    A B C D
    Civil 1 1
    MEP-PL 1
    MEP-EL 1
    MEP-DS 1
    MEP-VE 1
    STR 1
    Total 2 3 2 0

  2. sundaram
    07-24-2010 01:30 AM
    Help the needy
    If you can't help, try to show them who can help them.


Total Posts
Visitor Messages
Total Thanks
General Information
  • Last Activity: 09-30-2016 09:05 PM
  • Join Date: 05-28-2009
  • Referrals: 0


Showing Friends 1 to 1 of 1

All times are GMT -8. The time now is 10:28 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World