I need to Sum up Column i. First I was thinking since there is always and only 2 numbers in Col h and i then maybe i can use a reference with that. Thinking again as i looked.
You can see in Column B the first word always starts with Total before vendor name. Can you do a sumifs using that first name to add up the columns i ?(yellow) If so help would be great thanks.
You can see in Column B the first word always starts with Total before vendor name. Can you do a sumifs using that first name to add up the columns i ?(yellow) If so help would be great thanks.
| Book1 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | Fire | ||||||||||
| 2 | Bill | 10/21/2024 | 5556 | 5th Ave | 11/20/2024 | 1,464.37 | 1,464.37 | ||||
| 3 | Total Fire | 1,464.37 | 1,464.37 | ||||||||
| 4 | AIC | ||||||||||
| 5 | Bill | 11/06/2024 | 1161 | 5th Ave | 12/06/2024 | 500.00 | 500.00 | ||||
| 6 | Total AIC | 500.00 | 500.00 | ||||||||
| 7 | HHH Tech Corp | ||||||||||
| 8 | Bill | 07/01/2024 | 110 | 5th Ave | 07/31/2024 | 7,500.00 | 7,500.00 | ||||
| 9 | Total HHH Tech Corp | 7,500.00 | 7,500.00 | ||||||||
| 10 | Arrow | ||||||||||
| 11 | Bill | 10/01/2024 | 214 | 5th Ave | 10/31/2024 | 8,500.00 | 8,500.00 | ||||
| 12 | Bill | 11/11/2024 | 23 | 5th Ave | 12/11/2024 | 8,500.00 | 8,500.00 | ||||
| 13 | Bill | 12/13/2024 | 12 | 5th Ave | 01/12/2025 | 8,500.00 | 8,500.00 | ||||
| 14 | Bill | 01/10/2025 | 1235 | 5th Ave | 02/09/2025 | 8,500.00 | 8,500.00 | ||||
| 15 | Total Arrow | 34,000.00 | 34,000.00 | ||||||||
| 16 | |||||||||||
| 17 | Total | ||||||||||
Sheet1 | |||||||||||
