|
Home > Archive > FrontPage Server Extensions for Windows > August 2005 > Can Excel do a count if two or more cells equal certain criteria?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Can Excel do a count if two or more cells equal certain criteria?
|
|
| freefallr 2005-08-29, 5:56 pm |
| Can excel do a count after comparing two columns? Example: =countif A1:A10=
"a" and B1:B10="1"
| |
|
| And the question regarding FrontPage extensions is...?
Excel questions will get better answers in an Excel newsgroup,
such as news://msnews.microsoft.com/microsoft.public.excel
--
Ron Symonds
Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
"freefallr" <freefallr@discussions.microsoft.com> wrote in message
news:4B069DC9-9C9C-45EF-B892-65CE59DBDCD5@microsoft.com...
> Can excel do a count after comparing two columns? Example: =countif
> A1:A10=
> "a" and B1:B10="1"
|
|
|
|
|