SumIF is not working
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? |
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 |
Try
=SUMIF(Results!$AA$7:$AA$1000,A4&"-Single",Results!$D$7:$D$1000) In article , "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? |
Include the dash within the quotes...
=SUMIF(Results!$AA$7:$AA$1000,A4&"-Single",Results!$D$7:$D$1000) Hope this helps! In article , "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? |
All times are GMT +1. The time now is 06:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com