|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
12-17-2015, 12:57 AM
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
Need quick excel formula, countif
Hi all, any excel wizards here that can provide me with a formula to do the following?
A B C Order# Qty Product 333 3 Apple battery 288 1 Banana 489 3 Etc.. 093 2 333 1 Orange 280 1 288 1 I want to count the total amount of products sold per order so the result for 333 would be 4 since it sold 3 apple batteries and 1 orange. I would like to display this result in D2 |
|
|
|
12-17-2015, 01:29 AM
|
#2 | |
|
So Fucking Outlawed
Industry Role:
Join Date: Nov 2001
Posts: 5,114
|
Quote:
Read about it and you can create a quick formula https://trackpal.com/blog/vlookup-for-beginners/
__________________
ICQ 115433750 |
|
|
|
|
|
12-17-2015, 03:13 AM
|
#3 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Posts: 1,552
|
Or create a Pivot Table and group by Order# in there.
https://support.office.com/en-us/art...0-0cf0b9b880f7 |
|
|
|
