|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Countif with multiple criteria
This is great! Thanks!
"Gary Brown" wrote:
Check out Chip Pearson's site:
http://www.cpearson.com/excel/array.htm
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
"girasole" wrote:
Hi. I am trying to compose a function in an Excel 2003 spreadsheet that will
count the number of cells that meet two criteria--to count if there is a date
in one column AND if there is specific text in another column.
Column I contains dates (appearing as, for example, 7-Feb-08, but stored as
2/7/2008)
Column E contains text
I have been trying to find a function that would do something along the
lines of:
Count if column I contains a date (and is not blank) AND if column E
contains "GC"
Any suggestions would be greatly appreciated!
|