Formula Required -

[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

 

[Mike H.]

This seems to work:
=SUMPRODUCT((1)*(B3:B7=C1))

where C1 contains the project you are summarizing on.