SumProduct?
I thought Sumproduct would be correct for retrieving the correct information:
I am trying to have 2 different conditions filled and then sum'd 1st condition is to search for the number 1, 2, or 3 in a set of 5 cells in a row (there are 297 rows) 2nd condition is to search for the letter R in the same row in one certain cell. If both conditions are met than I want those rows to be summed. Formula I used was =SUMPRODUCT(--('Proof-Press'!I3:M3300),--('Proof-Press'!O3:O330="R")) all I get in return is !### error.. any help? |
Sum product needs to have the same size arrays in each condition
try =SUMPRODUCT(--('Proof-Press'!I3:I330+'Proof-Press'!j3:j330+'Proof-Press'!K3:K330+'Proof-Press'!L3:L330+'Proof-Press'!M3:M3300),--('Proof-Press'!O3:O330="R")) "Murph" wrote: I thought Sumproduct would be correct for retrieving the correct information: I am trying to have 2 different conditions filled and then sum'd 1st condition is to search for the number 1, 2, or 3 in a set of 5 cells in a row (there are 297 rows) 2nd condition is to search for the letter R in the same row in one certain cell. If both conditions are met than I want those rows to be summed. Formula I used was =SUMPRODUCT(--('Proof-Press'!I3:M3300),--('Proof-Press'!O3:O330="R")) all I get in return is !### error.. any help? |
I meant to add
or =sumproduct(--(sum(offset('Proof-Press'!I3:I330,0,0,1,5)0),),--('Proof-Press'!O3:O330="R")) "bj" wrote: Sum product needs to have the same size arrays in each condition try =SUMPRODUCT(--('Proof-Press'!I3:I330+'Proof-Press'!j3:j330+'Proof-Press'!K3:K330+'Proof-Press'!L3:L330+'Proof-Press'!M3:M3300),--('Proof-Press'!O3:O330="R")) "Murph" wrote: I thought Sumproduct would be correct for retrieving the correct information: I am trying to have 2 different conditions filled and then sum'd 1st condition is to search for the number 1, 2, or 3 in a set of 5 cells in a row (there are 297 rows) 2nd condition is to search for the letter R in the same row in one certain cell. If both conditions are met than I want those rows to be summed. Formula I used was =SUMPRODUCT(--('Proof-Press'!I3:M3300),--('Proof-Press'!O3:O330="R")) all I get in return is !### error.. any help? |
All times are GMT +1. The time now is 12:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com