Trying to add a formula in my spreadsheet that will add every amount in column AQ8:AQ200 if the date in AQ8:AQ200 is march.
The format for the date is 3-12-09.
Here is what I'm trying.
=SUMIF(AU8:AU200,MONTH=3,AQ8:AQ200)
Trying to add a formula in my spreadsheet that will add every amount in column AQ8:AQ200 if the date in AQ8:AQ200 is march.
The format for the date is 3-12-09.
Here is what I'm trying.
=SUMIF(AU8:AU200,MONTH=3,AQ8:AQ200)
Last edited by Gingerbreadman; 04-01-2009 at 01:27 PM.
Probably:
=SUMPRODUCT(--(MONTH(AQ8:AQ200)=3),AU8:AU200)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I tried that and I'm get a 0 as my value.
I think the column references in NBVC's formula need to be reversed based on your original SUMIF suggestion...
=SUMPRODUCT(--(MONTH(AU8:AU200)=3),AQ8:AQ200)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
The formula looks at dates (formatted as dates not text strings) in range AQ8:AQ200 and sums AU8:A200 as I thought was your requirement.. you may need to reverse the ranges if the reverse is true.
It works, Thanks for the fast response
Please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks