Sum Help

[jpet]

Hi,

Attached is a sample file, what I would like to do is SUM up all the hours for each app on the second worksheet. If I do a vlookup it only counts the first cell...my mind is a total blank...
Thanks and Happy Friday!

J

[Paul]

You can use one of two formulas for this on your summary sheet (Sheet2):

=SUMIF(Example!$A$2:$A$16,"A",Example!$D$2:$D$16)

or

=SUMPRODUCT((Example!$A$2:$A$16="A")*(Example!$D$2:$D$16))

Either one works. Note: Your "A" in cell A2 has a space after it, while the "A" in A3 and A4 don't. It will not see this as simply "A" due to this, so make sure there are no leading or trailing spaces.