I have two columns: 1) Servicers (column A) and 2) Current Note Rate (column B)
I'm trying to do a sumif where Current Note Rate is less than 0.0500 for a specific servicer. I got an error using this formula below. Please help!
=SUMIF('Blank_Report(6)'!$A:$A,Calculation!$A2,'Blank_Report(6)'!$B:$B<0.0500)
Thanks!
LH
Last edited by Dhoang25; 06-24-2011 at 03:41 PM.
Try:
=SUMIFS('Blank_Report(6)'!$B:$B,'Blank_Report(6)'!$A:$A,Calculation!$A2,'Blank_Report(6)'!$B:$B,"<0. 0500")
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Not sure why it doesn't work! Here is the worksheet!
Last edited by Dhoang25; 06-24-2011 at 03:24 PM.
What Excel version are you working with?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
MS Excel 2007
You seem to have a space in the 0.0500 in the formula:
Try again with:
=SUMIFS('Blank_Report(6)'!$B:$B,'Blank_Report(6)'!$A:$A,Calculation!$A2,'Blank_Report(6)'!$B:$B,"<0.0500")
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
thank you very much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks