Total of a specific name

T

Tia

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
 
B

Billy Liddel

Tia

An array formula entered Ctrl + Shift + Enter

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

You can copy down

Regards
Peter
 
T

Tia

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

copy across

--
__________________________________
HTH

Bob









- 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
 

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

Top