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
Bookmarks