Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

count with two criterias

1 view
Skip to first unread message

melvin....@gmail.com

unread,
Sep 19, 2007, 3:30:33 PM9/19/07
to
I need a formula that will count the the number of rows that meet the
criteria from two different columns, i..e.
How mant times does Ham & Cheese and $3.50 appear? It appears 2 times
with the given conditions.

Product Price
PB&J $2.00
Ham & Cheese $3.50
PB&J $2.50
PB&J $2.50
PB&J $1.50
Ham & Cheese $3.50
PB&J $2.00
PB&J $1.00

0 new messages