| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula that sums the values if you have 2 criteria and 2 differe.
I need a formula that sums the values with 2 different criteria and 2
different look up ranges |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
=sumif(...) +sumif(...)
Using this: http://www.officearticles.com/excel/...ft_excel.h tm ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
=sumproduct(--(rng1=value1),--(rng2=value2),rng1)
will sum the values in rng1 where the two criteria match -- HTH RP (remove nothere from the email address if mailing direct) "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
Some day, I'm going to make you or Zack teach me those dashy things, Bob.
************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... =sumproduct(--(rng1=value1),--(rng2=value2),rng1) will sum the values in rng1 where the two criteria match -- HTH RP (remove nothere from the email address if mailing direct) "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
Anne,
It's already written it up. See http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards Bob "Anne Troy" wrote in message ... Some day, I'm going to make you or Zack teach me those dashy things, Bob. ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... =sumproduct(--(rng1=value1),--(rng2=value2),rng1) will sum the values in rng1 where the two criteria match -- HTH RP (remove nothere from the email address if mailing direct) "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
OMG. I don't want to learn all that. :)
But I'll link to your site, for sure! ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... Anne, It's already written it up. See http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards Bob "Anne Troy" wrote in message ... Some day, I'm going to make you or Zack teach me those dashy things, Bob. ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... =sumproduct(--(rng1=value1),--(rng2=value2),rng1) will sum the values in rng1 where the two criteria match -- HTH RP (remove nothere from the email address if mailing direct) "Inga" wrote in message ... I need a formula that sums the values with 2 different criteria and 2 different look up ranges |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
"Anne Troy" wrote in message ... OMG. I don't want to learn all that. :) You can never learn too much, :-)) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
I'll stick with learning too much about Word and not quite enough about
Excel, k? :D Did you get the reply to my PM? ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... "Anne Troy" wrote in message ... OMG. I don't want to learn all that. :) You can never learn too much, :-)) |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 differe.
Yes I did thanks, just resurrecting the box.
-- HTH RP (remove nothere from the email address if mailing direct) "Anne Troy" wrote in message ... I'll stick with learning too much about Word and not quite enough about Excel, k? :D Did you get the reply to my PM? ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... "Anne Troy" wrote in message ... OMG. I don't want to learn all that. :) You can never learn too much, :-)) |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula that sums the values if you have 2 criteria and 2 diff
Thanks The link to the site was very helpful
"Bob Phillips" wrote: Yes I did thanks, just resurrecting the box. -- HTH RP (remove nothere from the email address if mailing direct) "Anne Troy" wrote in message ... I'll stick with learning too much about Word and not quite enough about Excel, k? :D Did you get the reply to my PM? ************ Anne Troy VBA Project Manager www.OfficeArticles.com "Bob Phillips" wrote in message ... "Anne Troy" wrote in message ... OMG. I don't want to learn all that. :) You can never learn too much, :-)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that only adds numbers that meet specific criteria | Excel Discussion (Misc queries) | |||
| Data Validation - Scroll in the formula bar for a custom criteria | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| formula that meets two criteria and sums? | Excel Discussion (Misc queries) | |||
| Need formula to check values of data in several cells as criteria | Excel Worksheet Functions | |||
Linear Mode
