DATES AND VALUE

R

rajaiy

Dear Sir
I need you help in my Table

1 I have one table with the orders I made in all the year.
2- and I have one table with total orders per month
my question is how I could add in the table no 2 the total of the value of
total payment in month.

dat of payment to be pay

28/1/09 28/1/09 4365
28/3/09 28/3/09 4766
26/2/09 26/2/09 5096
27/4/09 27/4/09 4177
27/4/09 27/4/09 12346
27/4/09 27/4/09 14595
27/4/09 27/4/09 2240 0
13/3/09 13/3/09 3536.7

total orders per month total payments per month
jan 1
feb 1
mar 2
apr 4
may 0
jun 0
jul 0
aug 0
sep 0
oct 0
nov 0
dec 0
 
S

Suleman Peerzade

Hi,

I can see table No. 2 below total orders per month, but could not get your
question can you please elaborate what exactly are you looking for.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade
 
R

rajaiy

Dear Sir

Thanks'

I need the total to be oay in teble 1 in the payment per month.

exs ( for march 2 payment 1 - 4766 2- 3536.7 = 8302.7 ) to be autu count in
table no 2 as
total orders per month total payments per month
 
R

rajaiy

THANKS I FOUND IT

=SUMPRODUCT((MONTH('דרישות 78'!$P$3:$P$200)=ROW(A2))*('דרישות 78'!R3:$R$200))
 

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