Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF function not working | Excel Worksheet Functions | |||
Working time and days | Excel Worksheet Functions | |||
Sumif or Sumproduct 2 criterias not working | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |