A
Akash
Hi,
Greetings!!
I have Seven Columns
A1. Client Details
2. Invoice Raised Date
3. Project Type - Project or Group
4. Month
5. No Of Invoice
6. Month wise No of Invoice for Project
7. Month wise No of Invoice for Group
In the the Cell No of Invoice i am using the following formula
=SUMPRODUCT(--(MONTH($b$3:$b$50)=ROW(b4)))
With the use of this formula i am getting no of invoices raised during
a particular month in a year.
Now i want a report Project wise and Group Wise.
How to do that
Thanks in Advance
Akash Maheshwari
Greetings!!
I have Seven Columns
A1. Client Details
2. Invoice Raised Date
3. Project Type - Project or Group
4. Month
5. No Of Invoice
6. Month wise No of Invoice for Project
7. Month wise No of Invoice for Group
In the the Cell No of Invoice i am using the following formula
=SUMPRODUCT(--(MONTH($b$3:$b$50)=ROW(b4)))
With the use of this formula i am getting no of invoices raised during
a particular month in a year.
Now i want a report Project wise and Group Wise.
How to do that
Thanks in Advance
Akash Maheshwari