Total of a specific name
 

hi

Im working on a workbook for invoicing

A10= PROJECT NAME
B10= TOTAL AMOUNT
C10=INVOICE # FOR MONTH 01/01/2008
D10= AMOUNT FOR MONTH 01/01/2008
E10=INVOICE # FOR MONTH 01/02/2008
F10=AMOUNT FOR MONTH 01/02/2008
J10=INVOICE # FOR MONTH 01/03/2008
H10=AMOUNT FOR MONTH 01/03/2008
AND I KEEP GOING WITH A NEW ONE EACH MONTH
WHAT I NEED IS
AA: ???????? TOTAL INVOICED
I WANT A FORMULA TO CALCULATE ALL THE AMOUNT PUTED IN THE AMOUT AREA
IN EACH MONTH FOR EACH PROJECT

TIA

Total of a specific name
 

=SUMIF(C:C,"<",$B:$B)

copy across

--
__________________________________
HTH

Bob

"Tia" wrote in message
...
hi

Im working on a workbook for invoicing

A10= PROJECT NAME
B10= TOTAL AMOUNT
C10=INVOICE # FOR MONTH 01/01/2008
D10= AMOUNT FOR MONTH 01/01/2008
E10=INVOICE # FOR MONTH 01/02/2008
F10=AMOUNT FOR MONTH 01/02/2008
J10=INVOICE # FOR MONTH 01/03/2008
H10=AMOUNT FOR MONTH 01/03/2008
AND I KEEP GOING WITH A NEW ONE EACH MONTH
WHAT I NEED IS
AA: ???????? TOTAL INVOICED
I WANT A FORMULA TO CALCULATE ALL THE AMOUNT PUTED IN THE AMOUT AREA
IN EACH MONTH FOR EACH PROJECT

TIA

Total of a specific name
 

Tia

An array formula entered Ctrl + Shift + Enter

=SUM(IF(MOD(COLUMNS(D:Z),2)=1,D10:Z10))

You can copy down

Regards
Peter

Total of a specific name
 

On Jul 15, 2:11*pm, "Bob Phillips" wrote:
=SUMIF(C:C,"<",$B:$B)

copy across

--
__________________________________
HTH

Bob

"Tia" wrote in message

...



hi

Im working on a workbook for invoicing

A10= PROJECT NAME
B10= TOTAL AMOUNT
C10=INVOICE # FOR MONTH 01/01/2008
D10= AMOUNT FOR MONTH 01/01/2008
E10=INVOICE # FOR MONTH 01/02/2008
F10=AMOUNT FOR MONTH 01/02/2008
J10=INVOICE # FOR MONTH 01/03/2008
H10=AMOUNT FOR MONTH 01/03/2008
AND I KEEP GOING WITH A NEW ONE EACH MONTH
WHAT I NEED IS
AA: ???????? TOTAL INVOICED
I WANT A FORMULA TO CALCULATE *ALL THE AMOUNT PUTED IN THE AMOUT AREA
IN EACH MONTH FOR EACH PROJECT

TIA- Hide quoted text -

- Show quoted text -

2 A B C
D E F J
H AA
3 Project name Contract $ Invoice # Amount $ Invoice
# Amount $ Invoice # Amount $ Total $$
4 Bone 100,000.00 1 5,000
$ 5 3,000$ 10
20,000$ ??????

I dont wana use the old way AA=(D4+F4+H$)
I WANT A FORMULA THAT GIVES ME THE TOTAL OF THE $$$ PUTED IN THE
AMOUNTS COLUMNS EXCLUDING THE INVOICE # COLUMNS EVEN IF INSERT MORE
COLUMNS "IT WILL CALCULATED WHENEVER I WRITE AMOUNT