LinkBack URL
About LinkBacks
I need to combine a IF/SUMIF and SUMPRODUCT statement. My current statement states: =SUMPRODUCT(H309:H606,P309:P606). I need the value to be returned only if column a = "ABC".
I need to combine a IF/SUMIF and SUMPRODUCT statement. My current statement states: =SUMPRODUCT(H309:H606,P309:P606). I need the value to be returned only if column a = "ABC".
Try...
=IF(A309="ABC",SUMPRODUCT(H309:H606,P309:P606),"")
HTH
Regards, Jeff
Thanks for the response, how do I use this same formula for a range of cells? If A309:A606 contains the initials "ABC", then SUMPRODUCT(H309:H606,P309:P606), otherwise 0.
In the range, A309:A606, what are you looking for? One cell out of all those has "ABC" or all?
Multiple cells in the range could have ABC.
So, if at least one of those cells has "ABC" then apply the sumproduct...
=IF(COUNTIF($A$309:$A$606,"ABC"),SUMPRODUCT(H309:H606,P309:P606),"")
Perfect, thank you.
You are very welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks