Count only if...

[Milos038]

Hi
I need help how to make formula for counting only if is matching word selected in other shell (from drop down list)
Example like on picture

Screenshot by Lightshot

thx

 

[oldbrewer]

=countif(A1:A10,"red") will count all the cells equal to red

 

[PlusX EAI]

Maybe you want something like this:

=SUMIF(C:C;G4;D:D)-SUMIF(C:C;G4;E:E)

in G4 and then copy down

 

[Milos038]

Maybe you want something like this:

=SUMIF(C:C;G4;D:D)-SUMIF(C:C;G4;E:E)

in G4 and then copy down

You are genius
you help me realy much

 

[Milos038]

But now I cant use this result for next calculation
I need result from "H" to use in next table but cant

 

[PlusX EAI]

Explain what you are trying to do ?

 

[Milos038]

I already have other table where I count in,out and sold items.
I need to calculate this result together with rest callculation
example

F3 is IN delivery
G3 is stocked items
H3is OUT
K3 is SUM

C3 is sum recived with previous operation what we already talked
I need to put in K3 formula: =F3+G3-H3+c3

 

[PlusX EAI]

The error says that you are double using a cell, so if your F,G,H values are already used in the "c" cell calculation, they may create an error. Try to clarify your formula and result.

 

[Milos038]

Resolved
I move table on other place