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..