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