SUMIF and COUNTIF functions
 

I'm trying to utilize the above functions in a multi-tabed workbook... I'm
trying to add and count various info... Mainly what I can't figure out, is
how to base the SUM of the sales column on the criteria of both column B and
C. Column be has a list of 20 names in it, and Column C has about 9 options.
Based on B ~ the person, and C ~ the source, I need a total...

Column A Column B Column C Column D
800.00 Susie Radio
400.00 John Newspaper
100.00 Susie Radio

For instance: If Susie was to sell 800.00 from the newspaper, and 400.00
from the radio, I'd need a total for Susie's radio ads.... Like wise I would
need a total for John's newspaper. But I need a formula that will
automatically calculate the sum column for the items in Column B and C....

PLEASE HELP!

SUMIF and COUNTIF functions
 

Hi

=SUMPRODUCT(--(B1:B100="Susie"),--(C1:C100="Radio"),A1:A100)


Ari Laanemets


"Heather" wrote in message
...
I'm trying to utilize the above functions in a multi-tabed workbook...
I'm
trying to add and count various info... Mainly what I can't figure out,
is
how to base the SUM of the sales column on the criteria of both column B
and
C. Column be has a list of 20 names in it, and Column C has about 9
options.
Based on B ~ the person, and C ~ the source, I need a total...

Column A Column B Column C Column
D
800.00 Susie Radio
400.00 John Newspaper
100.00 Susie Radio

For instance: If Susie was to sell 800.00 from the newspaper, and 400.00
from the radio, I'd need a total for Susie's radio ads.... Like wise I
would
need a total for John's newspaper. But I need a formula that will
automatically calculate the sum column for the items in Column B and C....

PLEASE HELP!