| View previous topic :: View next topic |
| Author |
Message |
rthurston77
General User
Joined: 17 Jun 2010
Posts: 8
|
 Posted: Fri Jun 18, 2010 11:35 am Post subject: CountIf Function on Multiple Sheets |
 |
|
How do I use a countif formula on one sheet of a database when the data is on a second sheet? I want to be able to differentiate between blue, red, yellow etc... I am able to use a countif function to count all the the data in a cell but not specifically how many blue, red etc...
Here is what I have so far ... =COUNTIF(Sheet2!A1:A20,"blue")
Figure it out! Here it is ...
=COUNTIF(Sweeps.D3:D28;"pmnt")
Have fun counting. |
|
| Back to top |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Sun Jul 04, 2010 7:38 am Post subject: |
|
|
To improve the content quality of the forum, please ...
Tag the thread as solved (edit the posting and add [Solved] in the subject line).
Forum admin/moderator or original poster can do this
Move the thread to the Calc subforum, where it belongs.
Forum admin/moderator action required |
|
| Back to top |
|
|
|
