Help creating formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

philamena - 31 Mar 2006 00:24 GMT

Hello!
I am trying to create a formula to count a range of cells only i
another range of cells is greater than or less than a certain number.
ex.
count a1:a30 if the corresponding T cell is greater than 1 and les
than 10
(oh I forgot to mention that this will be pulling from anothe
workbook)

Thanks in advance for all your help

Reply to this Message

Zack Barresse - 31 Mar 2006 00:30 GMT

Hi philamena,

Check out the COUNTIF function. :)

HTH

Signature

Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM

> Hello!
> I am trying to create a formula to count a range of cells only if
[quoted text clipped - 6 lines]
>
> Thanks in advance for all your help.

Reply to this Message