Ask Your Question

COUNTIF with multiplication.

asked 2017-04-14 10:43:15 +0200

bayindirh gravatar image

I'm trying to create a spreadsheet for counting various items of same type.

I have two columns. One is color, the other is count. I may have many rows containing the same value for color (e.g. Blue), I also have a count column, which shows how many items that I have for the same row (e.g. 3). So while counting instead of adding 1 for each row, I want to add count amount to the total sum for that color.

e.g. If a row contains Blue as color and 3 as count, I want to add 3 to the total number of blues.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-04-14 12:37:09 +0200

bayindirh gravatar image

I've found that SUMIF also did what I looked for. I gave the color values for condition, and the counts for sum range.

edit flag offensive delete link more

answered 2017-04-14 11:06:02 +0200

JohnSUN gravatar image
edit flag offensive delete link more


Wow, that's pretty interesting. Thanks. Can I move totals to another place? If I want to create a small table with it, for example?

bayindirh gravatar imagebayindirh ( 2017-04-14 12:34:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-14 10:43:15 +0200

Seen: 193 times

Last updated: Apr 14 '17