Hi,
I am having a little issue with a formula. I have a row that will contain numeric values and monetary values. I want to get the total of monetary values only.
I tried using this : =SUMIF(M7:R7,">$1") , however it returns the total for all columns in the row. I also tried to use a COUNTIF, formula , but that returned a null value. I've attached a sample of my spreadsheet. Any suggestions would be appreciated. (I) Burn Report for Fiscal Year 2014-2015.xlsx
Last edited by communistflamingo; 01-02-2015 at 12:15 PM.
You can use your headers to help you. Maybe something like this
=SUMPRODUCT(--(RIGHT(M4:R4,3)="$$$"),M7:R7)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Probably there will be more rows with data so:
Formula:
Please Login or Register to view this content.
will be ready for copying down.
Best Regards,
Kaper
Or, as interesting values are each second column,
Formula:Please Login or Register to view this content.
Another...
=SUMIF(M$4:R$4,"*$$$",M7:R7)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks