Try:
=SUMPRODUCT((A2:A1000="37")*(F2:F1000="VD")*G2:G1000)
(I had "37" wrapped in inverted commas, because you have it formated as text)
Try:
=SUMPRODUCT((A2:A1000="37")*(F2:F1000="VD")*G2:G1000)
(I had "37" wrapped in inverted commas, because you have it formated as text)
Last edited by Portuga; 04-14-2008 at 01:15 AM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their![]()
There is no such thing as a problem, only a temporary lack of a solution
That works great.
Thanks a lot!
Michael
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks