N
nshah
I want to get the averages of data points that fit a certain criteria.
I have a column of data that includes a bank's asset size and anothe
column that indicates how much was paid to acquire the bank.
my question is this, suppose i want to make a summary page that show
the average price paid for those banks with say $100 - $200 million i
assets, then an average for those banks with between $200 - $40
million, then an average for those banks with between $600 - $800 o
something
the key is, when using SUMIF and COUNTIF, how can I apply a range o
values? I am familiar with using SUMIF to simply get info if data fit
a criteria like ">500" or something but what to do when the critera i
a range
I have a column of data that includes a bank's asset size and anothe
column that indicates how much was paid to acquire the bank.
my question is this, suppose i want to make a summary page that show
the average price paid for those banks with say $100 - $200 million i
assets, then an average for those banks with between $200 - $40
million, then an average for those banks with between $600 - $800 o
something
the key is, when using SUMIF and COUNTIF, how can I apply a range o
values? I am familiar with using SUMIF to simply get info if data fit
a criteria like ">500" or something but what to do when the critera i
a range