Formula Required -

  • Thread starter Thread starter Akash
  • Start date Start date
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
 
This seems to work:
=SUMPRODUCT((1)*(B3:B7=C1))

where C1 contains the project you are summarizing on.
 
Back
Top