tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
OK here goes,
I,ve got a list of 30 numbers in a row and to the right of each number is the category (A,B,C OR D)
now what I'm trying to do is add up all the numbers for each category as you see below,
if the data was in columns I'd use sumif, so I'm looking for a way to sumif when the values are next to the categories
to make it simple it starts at column A so it category in A2 value in B2 and continues along for 30 values.
<TBODY>
</TBODY>so HOPEFULLY YOU CAN SEE FROM THIS I JUST WANT TOTALS FOR EACH category BUT ITS NOT SOMETHING I CAN GET?
any help would be great
Thanks
Tony
OK here goes,
I,ve got a list of 30 numbers in a row and to the right of each number is the category (A,B,C OR D)
now what I'm trying to do is add up all the numbers for each category as you see below,
if the data was in columns I'd use sumif, so I'm looking for a way to sumif when the values are next to the categories
to make it simple it starts at column A so it category in A2 value in B2 and continues along for 30 values.
<TBODY> </TBODY> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<TBODY>
</TBODY>
any help would be great
Thanks
Tony