Thread: Checking another column

Morning,

I have this formula:

=COUNTIF('Input Sheet'!$M:$M,"Homework")

Which counts the number of homeworks in column M on the input sheet.

I now need to amend this so that it will only count these if:

the value in C4, is in the column F in the input sheet.

Any help would be greatly appreciated.

Thanks

Hello,

in 2010 you can use Countifs()

=COUNTIFS(M:M,"homework",F:F,$C$4)

In earlier versions of Excel, you can use Sumproduct, but you cannot use whole column ranges

=SUMPRODUCT(($M$1:$M$100="homework")*($F$1:$F$100=$C$4))

cheers,