Can I tell a cell to look at the entire sheet for the chosen text and if
found look for a chosen condition and count the amount of times this
condition occurs?

I'm pretty sure some kind of of "IF" function will solve this but I
can't figure it out.

I've attached an example of the spread that I'm building. Thanks for
any help you can give me


+-------------------------------------------------------------------+
|Filename: Help.xlsx |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=202|
+-------------------------------------------------------------------+

--
CrewDog130
------------------------------------------------------------------------
CrewDog130's Profile: http://www.thecodecage.com/forumz/member.php?userid=612
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121983

CrewDog130;439693 Wrote:
Can I tell a cell to look at the entire sheet for the chosen text and if
found look for a chosen condition and count the amount of times this
condition occurs?

I'm pretty sure some kind of of "IF" function will solve this but I
can't figure it out.

I've attached an example of the spread that I'm building. Thanks for
any help you can give meI think you mean Sumproduct used like this:
*=SUMPRODUCT((D4:D100=A1)*(K4:K100<60)) *where A1 would be your text to
check for, this formula says look for all the cells that match A1 then
if their corresponding cell in column K is less than 60 COUNT it (you
stated count rather than sum), one thing to note with sumproduct is that
the ranges must be identical dimensions so if you have A1:A100 and are
counting in column B then you must use B1:B100.


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121983

Your attachment did not come through. A couple of questions... When you said
"entire sheet" did you really mean that... every cell, including the one the
formula is in? What are the "chosen conditions" you want to test for?

--
Rick (MVP - Excel)


"CrewDog130" wrote in message
...

Can I tell a cell to look at the entire sheet for the chosen text and if
found look for a chosen condition and count the amount of times this
condition occurs?

I'm pretty sure some kind of of "IF" function will solve this but I
can't figure it out.

I've attached an example of the spread that I'm building. Thanks for
any help you can give me


+-------------------------------------------------------------------+
|Filename: Help.xlsx |
|Download:
http://www.thecodecage.com/forumz/attachment.php?attachmentid=202|
+-------------------------------------------------------------------+

--
CrewDog130
------------------------------------------------------------------------
CrewDog130's Profile:
http://www.thecodecage.com/forumz/member.php?userid=612
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=121983

Simon Lloyd;439766 Wrote:
I think you mean Sumproduct used like this:
*=SUMPRODUCT((D4:D100=A1)*(K4:K100<60)) *where A1 would be your text to
check for, this formula says look for all the cells that match A1 then
if their corresponding cell in column K is less than 60 COUNT it (you
stated count rather than sum), one thing to note with sumproduct is that
the ranges must be identical dimensions so if you have A1:A100 and are
counting in column B then you must use B1:B100.

Thanks, That worked perfectly. all I had to due was put A1 in
quotations. I looked at the SUMPRODUCT formula but didn't understand it.
Thanks again for your help.


--
CrewDog130
------------------------------------------------------------------------
CrewDog130's Profile: http://www.thecodecage.com/forumz/member.php?userid=612
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121983

CrewDog130;440396 Wrote:
Thanks, That worked perfectly. all I had to due was put A1 in
quotations. I looked at the SUMPRODUCT formula but didn't understand it.
Thanks again for your help.

Glad we could be of help!


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121983