countifs on earlier version of excel
Missed the sheet references
=COUNTIF(Jan!G:G,B14)+COUNTIF(Jan!B:B,C2)
Mike
"Mike H" wrote:
Hi,
=COUNTIF(G:G,B14)+COUNTIF(B:B,C2)
Mike
"Aaron Hodson (Coversure)" wrote:
Hello,
I have been working on 2007 excel and used the below formula:
=COUNTIFS(JAN!G:G,B14,JAN!B:B,C2)
I have just noticed upon saving that this will not work on earlier versions
of excel.
How do I need to change the formula please to make it compatible?
Thanks
Aaron
|