=SUMIF(Jul:Jun!B54:F58,A4,Jul:Jun!D54:D58)

There's a typo in the range "Jul:Jun!B54:F58"
It should be a single col reference, not multiple

Try either:
=SUMIF(Jul:Jun!B54:B58,A4,Jul:Jun!D54:D58)
=SUMIF(Jul:Jun!F54:F58,A4,Jul:Jun!D54:D58)

depending on which col the data to match with A4 resides,
in col B or in col F

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sues" wrote in message
...
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.