Help please!

[XKUKII]

Hi everyone,

How am I able to put two sets of information from two different columns into one formula? I can do a formula using information from one column but I want to put two columns together.

This is the two separate formulas I'm using now:

=COUNTIFS($B$3:$B$400, ">=PK2G",$B$3:$B$400, "<=PK2G")


=COUNTIFS($C$3:$C$400, ">=5XL",$C$3:$C$400, "<=5XL")

But I want to see if I can't put both these formulas together?

Any help would be much appreciated :D

Thank you!

 

[L. Howard]

Try this.

Howard

=COUNTIFS($B$3:$B$400,">=PK2G",$B$3:$B$400,"<=PK2G") &" - " &COUNTIFS($C$3:$C$400, ">=5XL",$C$3:$C$400, "<=5XL")

 

[XKUKII]

Hi Howard! Thanks for helping me out!

I tried that formula and I got 12-3. I'm not too sure what that means though?

Im trying to get a number which shows me how many people from the PK2G team ordered, for example, 5XL shirts?

I hope this makes sense

 

[L. Howard]

Maybe this.

=SUMPRODUCT(($B$3:$B$400="PK2G")*($C$3:$C$400="5XL"))

Howard

 

[XKUKII]

Thanks Howard! Worked perfectly!

 

[XKUKII]

The formula given from Howard did work, however up until I reached 22 and downwards it doesn't seem to work anymore? Any idea why? Anyone?

 

[L. Howard]

The formula showing in T4 has 22 in " " (quotes) so it is looking for text. The T3 value looks to be a number, 22.

Looks like you need to refer to the cell in the row above the formulas, if I am reading this correctly.

So in cell L4 try this =SUMPRODUCT(($B$3:$B$400="PK2G")*($C$3:$C$400=L3)) then pull across.

Howard

 

[XKUKII]

Ahh yes thank you so so much Howard!! Finally lol. You saved my life! :D