Hi guys,
First and foremost, thanks for all the support I have been receiving from this house. I really appreciate you all.
Attached is a list of payments by companies. I want to get the weekly total payments using sumproduct function. I have this formular but it's not giving me what I want as it is returning error. =SUMPRODUCT((WEEKNUM($A$1:$A$162)=I3),$F$1:$F$162)
Kindly assist.
Try:Formula:
Please Login or Register to view this content.
OrFormula:Please Login or Register to view this content.
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
Thanks TMS. But the formular still gave the same error message.
WEEKNUM() cannot return an array of values you can create a helper column and do sumproduct
or
Try
J8Formula:Please Login or Register to view this content.
Drag down
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
With helper column in H
in H1
=WEEKNUM(A1)
copy down
in J8
=SUMIF(H:H,I8,F:F)
copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks