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