I am trying to use sumif to form a summary page as a Year to date from a
summary on each of twelve month worksheets which have a sumary using the
sumif on each page. This is my formula
=SUMIF(Jul:Jun!B54:F58,A4,Jul:Jun!D54:D58)
it just comes up with #VALUE. What is wrong with the formula.
I am using the same formula on each of the individual months sheets and it
works.