If Statement?
I am trying to avoid using a pivot table, but i might find that i need have
to use one. I have a list of names and a list of account types they opened. The name might open up multiple accounts during the day. I want to create a list (in another work book) that adds up the bankers specific total of accounts that day. Example Date Banker Account 1/1 Joe Checking 1/1 Sally Saving 1/1 Joe Savings So i want to add up all the savings accounts opened by joe. I think I need to do an "and" statement, but each time i do that, it comes back "TRUE" Is there a way to do an "AND" statement and a "COUNTIF" statement? |
If Statement?
One way:
=SUMPRODUCT(--(B2:B1000="Joe"),--(C2:C1000="Savings")) Note that the account type should be Saving or Savings, but not both, for most efficient calculation. In article , "John" wrote: I am trying to avoid using a pivot table, but i might find that i need have to use one. I have a list of names and a list of account types they opened. The name might open up multiple accounts during the day. I want to create a list (in another work book) that adds up the bankers specific total of accounts that day. Example Date Banker Account 1/1 Joe Checking 1/1 Sally Saving 1/1 Joe Savings So i want to add up all the savings accounts opened by joe. I think I need to do an "and" statement, but each time i do that, it comes back "TRUE" Is there a way to do an "AND" statement and a "COUNTIF" statement? |
All times are GMT +1. The time now is 12:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com