I'm trying to come up with a formula that goes into a historic data base and sums up purchase orders, as long as these are within a specific rage, and they belong to a specific customer.
I'm trying to come up with a formula that goes into a historic data base and sums up purchase orders, as long as these are within a specific rage, and they belong to a specific customer.
Hi.
If you can live with that, I would suggest adding a column for customer to your specific range, say at G4:G7.
Then a simple SUMIF function would do the job.
Godspeed!Please Login or Register to view this content.
Maybe this, in G10:
=SUMPRODUCT(SUMIFS($D$4:$D$13,$C$4:$C$13,F10,$D$4:$D$13,$G$4:$G$7))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks!!! This works!
Let me check if adding additional info is feasable
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks