software

Hello – need help with a formula. I’ve tried searching, looked through
about 30 threads but can’t find a match.I need to search a column for 3 different parameters (“RC”,”NC”,”RS”)
and if it finds it in a cell, I need to go to specific cell in another
column (same row) and read (“complete” or “not done”) then total all
those findings into the formula cell.I try to learn this stuff on my own, but my brain is just too tired
today...

Thanks
rdj--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile: www.excelforum.com/member.php...oamp;userid=32570
View this thread: www.excelforum.com/showthread...hreadid=523676Hi

Try something like this:
=IF(OR(A2=quot;RCquot;,A2=quot;NCquot;,A2=quot;RSquot;),quot;Completequot;,quot;Not donequot;)
You can then fill this formula down all of your rows. For a total use
COUNTIF():
=COUNTIF(C2:C1000,quot;Completedquot;)

Andy.
quot;redneck joequot; gt; wrote
in message ...
gt;
gt; Hello - need help with a formula. I've tried searching, looked through
gt; about 30 threads but can't find a match.
gt;
gt;
gt; I need to search a column for 3 different parameters (quot;RCquot;,quot;NCquot;,quot;RSquot;)
gt; and if it finds it in a cell, I need to go to specific cell in another
gt; column (same row) and read (quot;completequot; or quot;not donequot;) then total all
gt; those findings into the formula cell.
gt;
gt;
gt; I try to learn this stuff on my own, but my brain is just too tired
gt; today...
gt;
gt; Thanks
gt; rdj
gt;
gt;
gt; --
gt; redneck joe
gt; ------------------------------------------------------------------------
gt; redneck joe's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32570
gt; View this thread: www.excelforum.com/showthread...hreadid=523676
gt;

Can I combine the two into one formula?

I've got the countif part for the first parameter (NC,RC,RS) to pull.
Then if it sees one of those it needs to then check another specific
cell for the complete/not complete and sum those only all those. The
complete/not complete

The column containing the NC,RC,RS can also contain other (job) types,
but I only want to count the three listed, either complete.not
complete.

Make sense?

gt; Hi
gt;
gt; Try something like this:
gt; =IF(OR(A2=quot;RCquot;,A2=quot;NCquot;,A2=quot;RSquot;),quot;Completequot;,quot;Not donequot;)
gt; You can then fill this formula down all of your rows. For a total use
gt; COUNTIF():
gt; =COUNTIF(C2:C1000,quot;Completedquot;)
gt;
gt; Andy.
gt;
gt;
gt;
gt; quot;redneck joequot; gt;
gt; wrote
gt; in message
gt; ...
gt; gt;
gt; gt; Hello - need help with a formula. I've tried searching, looked
gt; through
gt; gt; about 30 threads but can't find a match.
gt; gt;
gt; gt;
gt; gt; I need to search a column for 3 different parameters
gt; (quot;RCquot;,quot;NCquot;,quot;RSquot;)
gt; gt; and if it finds it in a cell, I need to go to specific cell in
gt; another
gt; gt; column (same row) and read (quot;completequot; or quot;not donequot;) then total all
gt; gt; those findings into the formula cell.
gt; gt;
gt; gt;
gt; gt; I try to learn this stuff on my own, but my brain is just too tired
gt; gt; today...
gt; gt;
gt; gt; Thanks
gt; gt; rdj
gt; gt;
gt; gt;
gt; gt; --
gt; gt; redneck joe
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; redneck joe's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=32570
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=523676
gt; gt;--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile: www.excelforum.com/member.php...oamp;userid=32570
View this thread: www.excelforum.com/showthread...hreadid=523676
=COUNTIF(A1:A1000,quot;NCquot;) COUNTIF(A1:A1000,quot;RCquot;) COU NTIF(A1:A1000,quot;RSquot;)

But then you don't get to have the Complete Not-Completes filled in on
the other column--
kraljb
------------------------------------------------------------------------
kraljb's Profile: www.excelforum.com/member.php...foamp;userid=9955
View this thread: www.excelforum.com/showthread...hreadid=523676
Not sure if this is what you want or not:

=SUMPRODUCT((A1:A5000={quot;RCquot;,quot;NCquot;,quot;RSquot;})*(B1:B5000= quot;completequot;))

This gives you the number of times the word quot;completequot; appears in
column B and the letters RC, NC or RS appear in Col A on the same row.

Is that what you're looking for?--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=523676
not quite - I tried it and got an N/A. I'm sure I'm not explaining it
correctly.

in your formula, the A column individual jobs with corresponding job
types (of which there are many) I am only concerned with the three
listed. Then if it finds one in column A, it needs to look over to
column B and read the complete/not complete for this indiviual job.

maybe this will help?

If job type in column A is X,
then read cell X in same row, column B,
then if quot;completequot;,
sum all quot;completesquot; of job type X.??Cutter Wrote:
gt; Not sure if this is what you want or not:
gt;
gt; =SUMPRODUCT((A1:A5000={quot;RCquot;,quot;NCquot;,quot;RSquot;})*(B1:B5000= quot;completequot;))
gt;
gt; This gives you the number of times the word quot;completequot; appears in
gt; column B and the letters RC, NC or RS appear in Col A on the same row.
gt;
gt; Is that what you're looking for?--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile: www.excelforum.com/member.php...oamp;userid=32570
View this thread: www.excelforum.com/showthread...hreadid=523676
That is what the formula I gave you does. It looks at column A and if
the value found is either RC, NC or RS it looks at column B. If it
finds the word quot;completequot; in column B it counts it. The end result is
the total number of times RC and quot;completequot; are on the same row NC
and quot;completequot; are on the same row RS and quot;completequot; are on the same
row.

If that isn't what you want then I don't understand what you're looking
for.--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=523676
I'm sure I didn't so it right - i'll try again.

thanks

Cutter Wrote:
gt; That is what the formula I gave you does. It looks at column A and if
gt; the value found is either RC, NC or RS it looks at column B. If it
gt; finds the word quot;completequot; in column B it counts it. The end result is
gt; the total number of times RC and quot;completequot; are on the same row NC
gt; and quot;completequot; are on the same row RS and quot;completequot; are on the same
gt; row.
gt;
gt; If that isn't what you want then I don't understand what you're looking
gt; for.--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile: www.excelforum.com/member.php...oamp;userid=32570
View this thread: www.excelforum.com/showthread...hreadid=523676
I've been staring at this dang thing too long.

Note to self:
When testing a formula, enter in the value you are testing for.....
Thanks for your help - sorry to be a bit slow.--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile: www.excelforum.com/member.php...oamp;userid=32570
View this thread: www.excelforum.com/showthread...hreadid=523676
Does that mean it's working the way you need it to work (formula is
giving results that match the expected results)?

If so, you're welcome. Glad to help.

If not, we'll keep trying.--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=523676