I have a table of data that I need to sum up based on product code thereafter by customer. I have tried using nesting SUMIF and AND and also nesting SUMIF and LOOKUP but I think I may have the formula wrong. Any advice please???
I have a table of data that I need to sum up based on product code thereafter by customer. I have tried using nesting SUMIF and AND and also nesting SUMIF and LOOKUP but I think I may have the formula wrong. Any advice please???
Perhaps you should explore =SUMIFS()?
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Use SUMIFS if you want summimg up by both criteria. Probably uplaod a sample worksheet?
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks