Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello Thanks for reading.
I have 2 columns one has the Category and the other has the Time spent Example: A1=15 B1=Email A2=22 B2=Internet A3=43 B3=Hardware A4=23 B4=Internet You can see how cells B2 & B4 have the same category. What I would like to do is add them both together to get the total for internet (or any other category) so the result would be Internet = 45. I was thinking about using an IF statement something like: IF A1=internet add the value of B1 to the total. It would need to know that if it was in cell A7 to add B7 to the list. Any Ideas?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Totals on Seperate Page | Excel Discussion (Misc queries) | |||
adding to different totals dependant upon selection from drop down | Excel Worksheet Functions | |||
Formula for adding up totals of groups | Excel Discussion (Misc queries) | |||
Formula for adding totals from separate worksheets | Excel Discussion (Misc queries) | |||
Formula for adding several worksheet totals | Excel Discussion (Misc queries) |