| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct?
I want to combine a SumProduct formula with a CountIF.
I want to count all occurences of "Peter" that appear in column H, if "Paul" is in the corresponding row in column G. I am using 2007 and have tried conditional formating but cannot make it work. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumProduct?
Try this:
=SUMPRODUCT((H1:H1000="Peter")*(G1:G1000="Paul")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "JimG" wrote in message ... I want to combine a SumProduct formula with a CountIF. I want to count all occurences of "Peter" that appear in column H, if "Paul" is in the corresponding row in column G. I am using 2007 and have tried conditional formating but cannot make it work. Any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumProduct? Thanks T. Valko
Nevermind... I found a similar thread that answered my Q
Thanks to T. Valko!!!!!! "JimG" wrote: I want to combine a SumProduct formula with a CountIF. I want to count all occurences of "Peter" that appear in column H, if "Paul" is in the corresponding row in column G. I am using 2007 and have tried conditional formating but cannot make it work. Any suggestions? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumProduct?
JimG --
Excel 2007 has a couple of new functions, one of which should help. You can use =COUNTIFS to make it work: =COUNTIFS(H:H,"Peter",G:G,"Paul") Should work fine. HTH "JimG" wrote: I want to combine a SumProduct formula with a CountIF. I want to count all occurences of "Peter" that appear in column H, if "Paul" is in the corresponding row in column G. I am using 2007 and have tried conditional formating but cannot make it work. Any suggestions? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumProduct?
.... and will be faster than SUMPRODUCT
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "pdberger" wrote in message ... JimG -- Excel 2007 has a couple of new functions, one of which should help. You can use =COUNTIFS to make it work: =COUNTIFS(H:H,"Peter",G:G,"Paul") Should work fine. HTH "JimG" wrote: I want to combine a SumProduct formula with a CountIF. I want to count all occurences of "Peter" that appear in column H, if "Paul" is in the corresponding row in column G. I am using 2007 and have tried conditional formating but cannot make it work. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| SUMPRODUCT | Excel Discussion (Misc queries) | |||
| sumproduct | Excel Discussion (Misc queries) | |||
| Sumproduct | Excel Worksheet Functions | |||
| Can I use SUMPRODUCT for this? | Excel Worksheet Functions | |||
Hybrid Mode
