List out the 10 rows then and tell us what you get and what you expect.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jana" wrote in message
...
Did that on a seperate spreadsheet and even took out blank lines, only had
10
rows, didn't bring back the right value...ugh

"Bob Phillips" wrote:

That should be okay.

Start by reducing the range, and checking, to say

=SUMIF(F1:F167,"Batch"mG1:G167)

If okay, increase by a half, if not, decrease by a half. When it goes
wrong
check that range of data.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Jana" wrote in message
...
Here is my actual forumula: =SUMIF(F1:F334,"Batch",G1:G334), but it's
returning a number, just not the right one, do I have to do something
special
to account for the blank lines?

"Jana" wrote:

I have a large worksheet that has a product name and then in the
next
cell a
sum, how do I sum only those equal to a specific product name. I
have a
list
of the products at the bottom of my spreadsheet where I want to put
this
sum.
The worksheet is an export of data from a datase which brings over
blank
lines and rows that don't have data in them. ex below:
D06D548D VOIP34 Support Rating and Processing of Data Usage
11/03/2007 A Due: CS:5/1/07 QS:8/7/07 CCS Batch 500 635
Total Estimate Percentage 127%Total Hours 500 635
D06D548I Expansion of Event Master, UDF and CTD Monetary
Fields 11/03/2007 A Due: CS:5/1/07 QS:8/7/07 CCS Online 446 566
UDF 75 95
Batch 594 754
CTUPDATE 112
Total Estimate Percentage 127%Total Hours
1,227 1,558
I would like to have some kind of an IF statement I think that says
if
A1="Batch" then Sum all hours (keep in mind, major novice here and
not
sure I
am even giving the right terms). Right now, I have to Ctrl click
every
cell
that is for a specific product. I wind up having to sum several
cells
and
then a sum of those groupings because of excel's limit on the number
of
cells
that can be included in a formula.