software

Hi People,

I have Columns A and B full of data and I would like to be able to
Write a function (might have to be a Macro), to find how many times the
exact value 5.3 occurs occurs in column A.

I also want to be able to write a function or Macro that will search
for all the instances of 5.3 in column A and when it finds an instance,
take the value in the same row, but in column B and add it. So I will
end up with the total of the values in column B that are in same rows
as values of 5.3 in column A.

Any suggestions as to how I could do this?

All help will be much appreciated--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: www.excelforum.com/member.php...oamp;userid=31214
View this thread: www.excelforum.com/showthread...hreadid=520503One way, in say, C1: =SUMIF(A:A,5.3,B:B)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;coa01gsbquot; gt; wrote in
message ...
gt;
gt; Hi People,
gt;
gt; I have Columns A and B full of data and I would like to be able to
gt; Write a function (might have to be a Macro), to find how many times the
gt; exact value 5.3 occurs occurs in column A.
gt;
gt; I also want to be able to write a function or Macro that will search
gt; for all the instances of 5.3 in column A and when it finds an instance,
gt; take the value in the same row, but in column B and add it. So I will
gt; end up with the total of the values in column B that are in same rows
gt; as values of 5.3 in column A.
gt;
gt; Any suggestions as to how I could do this?
gt;
gt; All help will be much appreciated
gt;
gt;
gt; --
gt; coa01gsb
gt; ------------------------------------------------------------------------
gt; coa01gsb's Profile:
www.excelforum.com/member.php...oamp;userid=31214
gt; View this thread: www.excelforum.com/showthread...hreadid=520503
gt;

Cheers Max, that sounds simple will try it out.

Managed to do the first bit myself using COUNTIF--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: www.excelforum.com/member.php...oamp;userid=31214
View this thread: www.excelforum.com/showthread...hreadid=520503quot;coa01gsbquot; wrote:
gt; Cheers Max, that sounds simple will try it out.

You're welcome !

gt; Managed to do the first bit myself using COUNTIF

Glad to hear that. I missed the first bit, sorry lt;ggt;
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

Similar to the above:

I would also like to Know the max value of the values in column B in
rows for which the value in column A of the row is 5.3.

I would like to do similarly with calculating the 90th Percentile

And if possible a formula for use in a line graph that would only plot
the values in column B, that had a corresponding value of 5.3 in column
A

Any ideas?--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: www.excelforum.com/member.php...oamp;userid=31214
View this thread: www.excelforum.com/showthread...hreadid=520503quot;coa01gsbquot; wrote:
gt; .. I would also like to know the max value of the values in column B in
gt; rows for which the value in column A of the row is 5.3.

Some thoughts for the above part:

Try in say C2, array-entered (press CTRL SHIFT ENTER):
=MAX(IF(A1:A100=5.3,B1:B100))

Adapt the ranges to suit, but we can't use entire col refs

I'm not sure about your other parts
Hang around awhile for insights from others
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---