Hi,
I have done sumif function for the text filter but there is logic for few which has to be filter with two condition in same cell value.
Please help me out
Hi,
I have done sumif function for the text filter but there is logic for few which has to be filter with two condition in same cell value.
Please help me out
Not clear to me what you mean: Re-post your file the sample results in N4:P4..filter with two condition in same cell value.
... there are no cells with "New, Old" in TYPE if that is what you mean.
Hi John
In E5 cell - I want to look in O3 cell
Reattached excel to filter the critria in right hand side
I hope John seems to be busy ,,,, can someone help me out
This ???
in N3
=SUMIFS($D$3:$D$21,$A$3:$A$21,$L3,$B$3:$B$21,$M3,$C$3:$C$21,"New")
in O3
=SUMIFS($D$3:$D$21,$A$3:$A$21,$L3,$B$3:$B$21,$M3,$C$3:$C$21,"New")+SUMIFS($D$3:$D$21,$A$3:$A$21,$L3,$B$3:$B$21,$M3,$C$3:$C$21,"Old")
in P3
=SUMIFS($D$3:$D$21,$A$3:$A$21,$L3,$B$3:$B$21,$M3,$C$3:$C$21,"Existing")
Last edited by JohnTopley; 03-26-2016 at 07:15 AM.
Hi John
I want dynamic formula... so for example : Ramesh will not have New & Old.
Can be formula be fixed at that cell to check the sum of amount
I don't understand what you mean by "dynamic"; all parameters are variable (see attached) so it can't be more dynamic.
Thank you soo much .... i love it.... i will try to make some alter from your last thread
If your problem has been resolved please mark thread as solved ("thread Tools" at top of first post)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks