Help please!

XKUKII

New Member
Joined
Jun 1, 2015
Messages
7
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!


 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

L. Howard

Well-known Member
Joined
Oct 16, 2012
Messages
4,514
Try this.

Howard


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

XKUKII

New Member
Joined
Jun 1, 2015
Messages
7
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 :(
 

XKUKII

New Member
Joined
Jun 1, 2015
Messages
7

ADVERTISEMENT

Thanks Howard! Worked perfectly!
 

XKUKII

New Member
Joined
Jun 1, 2015
Messages
7
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?

Excel1_zpsmrrzpjby.png
 

L. Howard

Well-known Member
Joined
Oct 16, 2012
Messages
4,514
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

New Member
Joined
Jun 1, 2015
Messages
7
Ahh yes thank you so so much Howard!! Finally lol. You saved my life! :D
 

Watch MrExcel Video

Forum statistics

Threads
1,122,798
Messages
5,598,112
Members
414,214
Latest member
marketingnumbersguy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top