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

countif formula with 2 critrtia

1 view
Skip to first unread message

M.K

unread,
Nov 22, 2009, 8:46:01 AM11/22/09
to
Hi

howi do countif formula with 2 critrtia for example

A:A = ABCD
B:B > 0

so the resule will be sum of B:B if A:A =ABCD & B:B >0 for example

ABCD 2
FGHI -3
ABCD -5
ABCD 4
FGHI 2
ABCD 9

the result which matich with 2 critria = 3

Don Guillett

unread,
Nov 22, 2009, 8:57:34 AM11/22/09
to
See my ans in your PREVIOUS post

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguil...@austin.rr.com
"M.K" <M...@discussions.microsoft.com> wrote in message
news:A01CD12E-D647-4EF4...@microsoft.com...

Per Jessen

unread,
Nov 22, 2009, 8:55:21 AM11/22/09
to
Hi

If you are using excel 2007, you can use COUNTIFS, else you have to use
SumProduct:

SUMPRODUCT(--(A1:A10="ABCD"),--(B1:B10>0))

Regards,
Per

"M.K" <M...@discussions.microsoft.com> skrev i meddelelsen
news:A01CD12E-D647-4EF4...@microsoft.com...

0 new messages