LinkBack URL
About LinkBacks
Hi - have another sumproduct problem after last week solved the filter issue
Enclosed is issue - I need to sum the Value for each department in that week ( i.e. Units phased * Static SP )
Please can someone help ?
many thanks
Peter
Hi - have another sumproduct problem after last week solved the filter issue
Enclosed is issue - I need to sum the Value for each department in that week ( i.e. Units phased * Static SP )
Please can someone help ?
many thanks
Peter
Using your sample workbook, this formula, copied across, returns the extended values
These are the results:
Please Login or Register to view this content.
Is that something you can work with?
FORMULA to total £sales
=SUMIF($B$3:$B$8,B15,$C$3:$C$8)
FORMULA to total sales volume
=SUMIF($B$3:$B$8,$B14,D$3:D$8)
see attached workbook
fantastic thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks