sum cells of one column that eqaul similar text in another column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on the completion of a timesheet. I am trying to sum the hours
in Coulmn G (9-22), with text that may be equal to four categories (types of
Leave... ANNUAL, SICK, COMP, or OTHER in Column H) ... so... I want to sum
only ANNUAL hours with ANNUAL hours, SICK with SICK, and so on... wish I
could explain it better. If someone wants to help me out or suggest anything
I appreciate it in advance. I've tried a lot of things... and am becoming
frustrated.
 
Hi!

Try either of these:

=SUMIF(H9:H22,"sick",G9:G22)

=SUMPRODUCT(--(H9:H22="sick"),G9:G22)

Biff
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtraction formula with Text error 7
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
Formating cells 1
Sum question 7
Annual Wages Sheet to pick up info from Time Sheet 2
Using other equations inside of SUM? 1
Sum up cells in column A that has same text in Column B. 4
conditional formats affect other cells 8

Back
Top