Hello All
Please see the attached Sample Date
I need K19 to return total qty based on column G text, So K19 is returning the total of Chrome - Inclusion
Any help would be great
Paul
Hello All
Please see the attached Sample Date
I need K19 to return total qty based on column G text, So K19 is returning the total of Chrome - Inclusion
Any help would be great
Paul
hi paul. try this in K19:
=SUMIF(G:G,J19,I:I)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Have you tried SUMIF ?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
In K19
=SUMIF(G:G,$J19,F:F)
copy down
L19=SUMIFS(I:I,G:G,J19)
Try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Based on the highlighted columns, I'd go withcopied downFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks