Help with multiconditional sumif with range

Hoping to get help with this formula....I need 2 conditions to be true from 2 differnt columns, then I want to sum together in another column all the numbers that meet the 2 criteria, currently I have it that it counts the number of times that criteria is true, i need it to sum the numbers together...as an example

A, B, C
1220.50, -, 5
1220.50, -, 10
1220.50, +, 2

if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is the count, i am looking for the SUM, it should give me 15...thanks.

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>

Check out Chip Pearson's SumIf for Multiple Criteria at...

http://www.cpearson.com/excel/array.htm

Then browse his web site, http://www.cpearson.com.
It's one of the best Excel sites around.

HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"MaxTomas" wrote:

>
> Hoping to get help with this formula....I need 2 conditions to be true
> from 2 differnt columns, then I want to sum together in another column
> all the numbers that meet the 2 criteria, currently I have it that it
> counts the number of times that criteria is true, i need it to sum the
> numbers together...as an example
>
> _A,_B,_C_
> 1220.50, -, 5
> 1220.50, -, 10
> 1220.50, +, 2
>
> if a =g5(1220.50) and B="-" then sum C. my formula gives me 2 which is
> the count, i am looking for the SUM, it should give me 15...thanks.
>
>
> --
> MaxTomas
> ------------------------------------------------------------------------
> MaxTomas's Profile: http://www.excelforum.com/member.php...o&userid=24683
> View this thread: http://www.excelforum.com/showthread...hreadid=382578
>
>