Remember Me?

#1
March 22nd 05, 04:43 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Mar 2005 Posts: 5
COUNTIF Multiple Criteria

I need a formula that will look count the number of occurrences in one column
that equal a criteria only if the a criteria in another column is met.
Neither of the two columns contain numbers.

For instance Column A has a type of fruit, column B has the seller of the
fruit. I need to know how many of a particular fruit the specified seller
sells.

Thank you!
--
Lori
--
Lori

#2
March 22nd 05, 04:56 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Nov 2003 Posts: 11,272
COUNTIF Multiple Criteria

=SUMPRODUCT(--(A1:A100="apple"),--(B1:B100="Bill"))

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Lori Hornick" wrote in message
...
I need a formula that will look count the number of occurrences in one

column
that equal a criteria only if the a criteria in another column is met.
Neither of the two columns contain numbers.

For instance Column A has a type of fruit, column B has the seller of the
fruit. I need to know how many of a particular fruit the specified seller
sells.

Thank you!
--
Lori
--
Lori

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Allen Excel Discussion (Misc queries) 0 January 19th 10 06:51 PM WLMPilot Excel Worksheet Functions 5 February 5th 09 11:48 PM NeedExcelHelp07 Excel Worksheet Functions 1 December 12th 07 05:47 PM JJ Excel Worksheet Functions 1 December 28th 04 06:37 PM Jeff Excel Programming 1 June 29th 04 02:51 PM

All times are GMT +1. The time now is 12:31 PM.