G
Guest
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!
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!