Count & Total

[Alex501]

Hi All

I have a spreadsheet with a list of invoices the date of the invoice and the value. I have then created another sheet which in effect is an overview by month. As follows;

List

Overview

What formulas can I use to count the total invoices in a month (in the No column) and then total the of a months invoices (in the value column)?

Thanks in advance.

Alex

 

[Fluff]

If A1 is an actual date & the 1st of the month you could use

=COUNTIFS(Lists!A:A,">="&A1,Lists!A:A,"<"&EOMONTH(A1,0)+1)

=SUMIFS(Lists!C:C,Lists!A:A,">="&A1,Lists!A:A,"<"&EOMONTH(A1,0)+1)