I am getting an error to include two conditions in one formula
I am getting an error which says "You've entered too few arguments for this function". This formula is given below
=IF(B2&C2&J2=B2&"DE",B2&"Audit"&"COMPLETED",SUMIFS($I$2:I2,$M$2:M2,M2,$C$2:C2,"DE","Audit",$E$2:E2,E2),"")
Please help me with it.
Thanks,
Danish
Last edited by Danish Jasnaik; 12-09-2019 at 10:43 PM. Reason: Title not matching the criteria of the forum
Without more detail it's hard to help, but the problem with your Formula as it stands is that you've got "Audit" where SUMIFS is expecting a range of cells.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
OK, I am attaching my sheet here, could please have a look at it and tell me whats wrong here?
Last edited by Danish Jasnaik; 12-09-2019 at 06:42 AM.
Made the changes
An if statement is if(condition, true, false)
=IF(B2&C2&J2=B2&"DE",B2&"Audit"&"COMPLETED",SUMIFS($I$2:I2,$M$2:M2,M2,$C$2:C2,"DE","Audit",$E$2:E2,E2),"")
the last bit of your formula is a condition too many and you have De and audit borth as criteria
=IF(B2&C2&J2=B2&"DE",B2&"Audit"&"COMPLETED",SUM(SUMIFS($I$2:I2,$M$2:M2,M2,$C$2:C2,{"DE","Audit"},$E$2:E2,E2)))
Hi there,
Thanks for the formula, however I need both the criteria "DE" and "Audit" to be in the formula. Is there any way in which I can do it?
Have you even looked at the formula I posted? it includes DE and Audit. Is it not working?
Yes I did check that formula, it is not working
@Danish Jasnaik
Please read my post #3 and abide by the forum rules. Your change is not satisfactory and in accordance with the forum rules. Tell us your issue in specific terms.
Note: No help to be offered this thread until OP complies with forum rules regarding thread title.
@alansidman really sorry for not meeting the rules of the forum. I have update my title. Please let me know if that's fine.
Thank You for changing the title.
Please explain what "not working" means, as I applied davsth's formula into column K (I guessed as to where the formula is supposed to go) and got values.
If they aren't the correct values then it may help to show us the values you do expect.
Also "Audit" isn't shown in column C so we may need another sample file that shows what values you expect to see when "Audit" is in column C.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks