An Quala
Board Regular
- Joined
- Mar 21, 2022
- Messages
- 146
- Office Version
- 2021
- Platform
- Windows
Hello everyone, this data has 3 boxes, it has campaign names and their respective data, I want to add one more column in which I want to SUM up the data from these 3 columns, but the problem is that the campaign name for example "(SH)" is in different row in all 3 columns and it could come in any row randomly in the first 100 rows in column A, M and Y.
I need an excel formula (not the VBA code) that sums up all the data for example impressions of (SH) in all 3 boxes, which will be 11408 in this given data,
In case if value is appearing only in 2 columns out of 3 it should only sum up those 2 without giving error and so on for only 1.
Looking forward to your help.
I need an excel formula (not the VBA code) that sums up all the data for example impressions of (SH) in all 3 boxes, which will be 11408 in this given data,
In case if value is appearing only in 2 columns out of 3 it should only sum up those 2 without giving error and so on for only 1.
Looking forward to your help.
| Reporting Dummy Data.xlsx | |||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | AT | AU | |||
| 1 | Sponsored Products Campaigns | Sponsored Brands Campaigns | Sponsored Display Campaigns | All Types | |||||||||||||||||||||||||||||||||||||||||||||
| 2 | Campaign Name (Informational only) | Impressions | Clicks | Spend | Sales | Orders | Units | ACOS | CVR | CPO | Number of Campaigns | Campaign Name (Informational only) | Impressions | Clicks | Spend | Sales | Orders | Units | ACOS | CVR | CPO | Number of Campaigns | Campaign Name (Informational only) | Impressions | Clicks | Spend | Sales | Orders | Units | ACOS | CVR | CPO | Number of Campaigns | Campaign Name (Informational only) | Impressions | Clicks | Spend | Sales | Orders | Units | ACOS | CVR | CPO | Number of Campaigns | |||||
| 3 | (SH) | 8700 | 27 | 24.23 | 41.94 | 6 | 6 | 58% | 22% | 4.04 | 13 | E | 3185 | 57 | 27.67 | 55.92 | 7 | 8 | 49% | 12% | 3.95 | 11 | E | 2381 | 6 | 2.74 | 6.99 | 1 | 1 | 39% | 17% | 2.74 | 2 | E | |||||||||||||||
| 4 | (CP) | 6212 | 32 | 22.2 | 35.7 | 5 | 6 | 62% | 16% | 4.44 | 51 | (SH) | 2708 | 9 | 4.66 | 5.95 | 1 | 1 | 78% | 11% | 4.66 | 71 | (CP) | 843 | 1 | 0.22 | 0 | 0 | 0 | 0% | 0% | 0.00 | 16 | (CP) | |||||||||||||||
| 5 | E | 2635 | 8 | 7.56 | 6.99 | 1 | 1 | 108% | 13% | 7.56 | 5 | (CP) | 704 | 9 | 6.17 | 6.99 | 1 | 1 | 88% | 11% | 6.17 | 5 | (SH) | 0 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0.00 | 0 | (SH) | 11408 | ||||||||||||||
Sheet1 | |||||||||||||||||||||||||||||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| AL5 | AL5 | =B3+N4+Z5 |
