Sum IF Indirect help

[joshparry6]

Hi,

I have the following formula:

=SUMIF(INDIRECT("'"&C6&"'!A:A"),H1,INDIRECT("'"&C6&"'!C:C"))

How can I amend it whereby the criteria is if cells begin with the text in cell H1?


Thanks in Advance
JP

 

[RoryA]

Like so:

=SUMIF(INDIRECT("'"&C6&"'!A:A"),H1&"*",INDIRECT("'"&C6&"'!C:C"))

 

[joshparry6]

Thank you Rory!!!!

 

[RoryA]

Glad we could help.