Hi,
I am trying to use the Countifs function in order to count cells based on two conditions, 1 being in a cell and 1 a specific word - I have tried the below but I am coming up with a #value! error.
=COUNTIFS(November!E9:E377, "=" & Summary!E7,November!G9:AJ377,"HOL")
Is anyone able to offer some advice please.
Many thanks
Bookmarks