LinkBack URL
About LinkBacks
How to write formula for entering a value of a cell if values of 3 cells are true.
For example,
If A2:A10 = X,
and
If B3:B15 = Y,
and
If C3:C25 = Z,
Then
Enter the sum of the values of D10:D25
Is this possible?
Thank you
Entering values based on 3 conditions
How to write formula for entering a value of a cell if values of 3 cells are true.
For example,
If A2:A10 = X,
and
If B3:B15 = Y,
and
If C3:C25 = Z,
Then
Enter the sum of the values of D10:D25
Is this possible?
Thank you
Last edited by jkarthi22; 07-22-2011 at 02:02 AM. Reason: not compliying to the forum rule
I have changed the title, hope it is ok
Last edited by jkarthi22; 07-22-2011 at 02:08 AM.
Please read my signature about quoting entire posts !
Please read forum rules !
Try this:Originally Posted by jkarthi22
=IF(COUNTIF(A2:A10,"X")+COUNTIF(B3:B15,"Y")+COUNTIF(C3:C25,"Z")=ROWS(A2:A10)+ROWS(B3:B15)+ROWS(C3:C25),SUM(D10:D25),"check")
Hi jkarthi22
find the attatched file
Please help me
what more help is needed
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks