Here's a 2nd try (apologies for the earlier mistake) ..

In your summary sheet
-------------------------------
Suppose you list in B3:C3
the names of the sheets: Jun, Jul
you could try say,

In B4:

=SUMPRODUCT(SUMIF(INDIRECT("'"&$B$3:$C$3&"'!B54:B5 8"),$A4,INDIRECT("'"&$B$3:
$C$3&"'!D54:D58")))

The above will return the same results
as doing a total of the 2 SUMIFs
(from the sheets: Jun and Jul)

=SUMIF(Jun!B54:B58,$A4,Jun!D54:D58)+SUMIF(Jul!B54: B58,$A4,Jul!D54:D58)

--
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.