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? |
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? |
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? |
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? |
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? |
All times are GMT +1. The time now is 02:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com