Formula To Count

  • Hi, if data in column a w/s data mathes cell c2 w/s geninfo then i want it to count that cell and give me a total for all those matching my criteria.. im not good with formulas. all help is greatly appreciated..

    im using counta right now, but that just counts it all.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]sorry, i should have been more direct.. i am using countif below

    =COUNTIF(Data!F:F,'Gen Info.'!C5)

    but, what i am having trouble with is coming up with

    if Data F:F = C5 then
    if Data I:I = "Active" then Count..

    "To know the road ahead, ask those coming back.":fatwalk:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!