It will if you put the the - sign inside the " ".
ie. =SUMIF(Results!$AA$7:$AA$1000,A4&"-Single",Results!$D$7:$D$1000)
DanVDM Wrote:
Results Spreadsheet
Range AA7 value is equal to "Server1-Single"
Range D7 value is 10
Counter Spreadsheet
Range A4 value is "Server1"
Formula in Range B4 is
=SUMIF(Results!$AA$7:$AA$1000,A4&-"Single",Results!$D$7:$D$1000)
Shouldn't this give me a value of 10?
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=387992