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

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