#### XKUKII

##### New Member
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!

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
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")``

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

Maybe this.

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

Howard

Thanks Howard! Worked perfectly!

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?

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

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

Replies
1
Views
136
Replies
8
Views
359
Replies
1
Views
218
Replies
0
Views
47
Replies
5
Views
130

1,196,152
Messages
6,013,742
Members
441,781
Latest member
Gian Carlos

### 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.

### Which adblocker are you using?

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

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