Invoice Log - Formaula Help

**kriscons** · 03-15-2017, 08:07 AM

Hi all

I need some help with adding/creating a formula to my invoice log and any help would be hugely appreciated.

From A6 to A17 I have the months of the year in order of our financial year (March - February).

From A23 down, I will be inserting invoice data. Each row will contain a Date (e.g. 15/03/2017) and a Price amongst other things and I need to aggregate the price values for all rows and show that aggregated price value next to the months (B6-B17) so we can see easily how much income we are expecting to invoice for each month.

I have attached the screenshot of that area of the invoice log.

Any offers of help would be hugely appreciated.

Thanks
Kris

**southward** · 03-15-2017, 08:41 AM

Hi,

I think a SUMIFS formula will work for you.

Something like this:

=SUMIFS(C:C,A:A,">="&MONTH(DATEVALUE(A6&" 1")),A:A,"<="&EOMONTH(DATEVALUE(A6&" 1"),0),B:B,"d")

The end of it is for the criteria in column B.

Attached is an example.

Hope this makes sense and is helpful.

Cheers

**kriscons** · 03-15-2017, 09:11 AM

Thank you, thats really helpful.

**southward** · 03-15-2017, 01:24 PM

You are very welcome. Glad I could be of some assistance.

Cheers

Invoice Log - Formaula Help

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Invoice Log - Formaula Help

Re: Invoice Log - Formaula Help

Re: Invoice Log - Formaula Help

Re: Invoice Log - Formaula Help

Thread Information

Users Browsing this Thread

Similar Threads

Looking for a formaula that will look up a food cycle

Looking for a formaula that will look up a food cycle

Formaula to convert data

formaula problem

A4 date of invoice - E4 invoice status - F4 Date invoice was paid - G4 number of days invo

Excel Formaula

Formaula to multiply and add

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions