Hello,
Refer attached file for sample data and desired result.
I am looking for formula which will give me desired result of progressive sum for the conditions matching against columns and row.
Thanks in advance.
Best Regards.!
Hello,
Refer attached file for sample data and desired result.
I am looking for formula which will give me desired result of progressive sum for the conditions matching against columns and row.
Thanks in advance.
Best Regards.!
In Cell C9:
Formula:Please Login or Register to view this content.
Confirm with Ctrl + Shift + Enter
Please hit the "Add Reputation" button if you liked the answer.
Shashank Mishra
Please hit "Add Reputation" Button if you liked the answer.
Thanks.! It worked for me.
Reputation added.!
Non-array alternative
=SUMPRODUCT(($E$4:$E$7=$C$3)*($F$4:$F$7=$C$4)*($G$3:$R$3>=$C$5)*$G$4:$R$7)
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks