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?

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?