Good Afternoon all,
can some one help me with the formula for sumproduct of a filtered rows attaching a sample data excel
i tried with offset but it is not working some mistake i am doing it
Good Afternoon all,
can some one help me with the formula for sumproduct of a filtered rows attaching a sample data excel
i tried with offset but it is not working some mistake i am doing it
which answer required? Enter your required amount.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
in H22 cell ,if i select exchange rate of 70 it should show 494.64
or if i select 100 pcs in filter that it should show 376.55
Please try
=SUMPRODUCT(F9:F16,G9:G16,1/H9:H16,SUBTOTAL(3,OFFSET(F9,ROW(F9:F16)-ROW(F9),)))
it works fine thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks