Cryptographic_ICE@yahoo.com

Guest
##
Adding category totals

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??

## Bookmarks