Formula Problems
 

I have 100 different invoices with the same PO#, I want to add all of the
invoices# with that po# to come up with one total to put on sheet two, in
other words, i want a running total for the month and ytd, i don't know what
to use, i've tried the sumif but i can't get just one total for each po#
--
Still Learning

Formula Problems
 

"still learning" wrote:
I have 100 different invoices with the same PO#, I want to add all of the
invoices# with that po# to come up with one total to put on sheet two, in
other words, i want a running total for the month and ytd, i don't know what
to use, i've tried the sumif but i can't get just one total for each po#

You didn't really describe what you tried and what was wrong with the
results, what you got instead, what it actually represented instead of
what you wanted. If you can determine such things yourself you would
help yourself or help those trying to help.

Since you are checking both date and PO then you would want to
to use SUMPRODUCT.
Summarizing Data Examples (an Overview)
http://www.mvps.org/dmcritchie/excel/sumdata.htm

Specifically for your question
http://www.eggheadcafe.com/software/...-a-date-r.aspx

Make sure your P.O. is always text or always a number.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm