Ask Your Question
0

Conditional Counting Using Multiple Columns [closed]

asked 2014-04-04 19:23:38 +0200

MizOldB gravatar image

Hi,

I have a column which represents a category (1, 2, 3, 4).

I have counted the amount of each category using the following condition:

=COUNTIF(F2:F331,"=2")

Produces the number in the category "2" etc.

I have another column which contains either 0 or 1.

I would like to have a condition that counts the amount of 1's for every category.

I.e.:

IF CATEGORY = "3" AND OTHERCOLUMN = "1" ADD 1 TO COUNT

All advice appreciated.

Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 18:28:02.333668

1 Answer

Sort by » oldest newest most voted
0

answered 2014-04-04 20:52:44 +0200

m.a.riosv gravatar image

There is the COUNTIFS(range1;criteria1;range2;criteria2;range3;criteria3) function.

=COUNTIFS(F2:F331,"=2",G2:G331,4)
edit flag offensive delete link more

Comments

Thank you!

Elias gravatar imageElias ( 2016-12-31 19:22:27 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2014-04-04 19:23:38 +0200

Seen: 3,051 times

Last updated: Apr 04 '14