G
GORDON
The next question is instead of checking for "E" in column G, I need t
sum the values in column H so that when I get an answer for
particular month it will tell me how much money I received for tha
month. Is the sum function the same as the sumproduct. I hav
difficulty using arrays in that the spreadsheet is a shared workbook.
I thank anyone who can give me ideas.
=SUMPRODUCT((MONTH(MTA!$F$16:$F$100)=MTA!$A$2)*(Y
AR(MTA!$F$16:$F$100)=MTA!$
B$6)*(G16:G100="E")*1)
presuming the range to check for E is G16:G100.
This does not need to be array-entered
sum the values in column H so that when I get an answer for
particular month it will tell me how much money I received for tha
month. Is the sum function the same as the sumproduct. I hav
difficulty using arrays in that the spreadsheet is a shared workbook.
I thank anyone who can give me ideas.
=SUMPRODUCT((MONTH(MTA!$F$16:$F$100)=MTA!$A$2)*(Y
AR(MTA!$F$16:$F$100)=MTA!$
B$6)*(G16:G100="E")*1)
presuming the range to check for E is G16:G100.
This does not need to be array-entered