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)

Originally Posted by DanVDM

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?

Try

=SUMIF(Results!$AA$7:$AA$1000,A4&"-Single",Results!$D$7:$D$1000)


In article <#[email protected]>,
"DanVDM" <[email protected]> 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 <#[email protected]>,
"DanVDM" <[email protected]> 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?