CountIF and Hlook Up Togeather

[sreeni85]

I would need the count of Number 1 in the B column, I tried count IF, but still a separate Hlook up is required.

Can someone help me out with the countif and hlookup formula in same cell.

enclosed sample excel

[Sam Capricci]

you need to be more clear, why is a countif not sufficient? What results are you looking for?

[martindwilson]

in c12
=COUNTIF(INDEX($B$3:$D$6,0,MATCH(B12,$B$2:$D$2,0)),1)

[Fotis1991]

Do you mean?

Please Login or Register  to view this content.

[Tony Valko]

Maybe this...

Entered in D12 and copied down:

=COUNTIF(INDEX(B$3:D$6,,MATCH(B12,B$2:D$2,0)),C12)

[martindwilson]

er tony that wouldnt that try to count the number of "A"'s
=COUNTIF(INDEX($B$3:$D$6,0,MATCH(B12,$B$2:$D$2,0)),1) counts the number of 1's

[Tony Valko]

My formula does count the 1's.

In the sample file cell C12 contains a 1. I assume that's the count criteria.

[sreeni85]

in c12
=COUNTIF(INDEX($B$3:$D$6,0,MATCH(B12,$B$2:$D$2,0)),1)

Many Thanks for this !!!..it worked !!

[martindwilson]

ahh i see i thought that was b12 wonky eyes