W
wx4usa
I have column A which is the year
I have column B which has any data
I have column C which has a dollar amount
I need a sumproduct formula that will look at year=2007, then any row
in column B with data of any kind, then total the dollar amounts in
column C
The B data is either text, numeric or empty cells I just want total
dollars of column C that corresponds to nonblank cells in column B and
2007 in column A
Is that possible?
I have column B which has any data
I have column C which has a dollar amount
I need a sumproduct formula that will look at year=2007, then any row
in column B with data of any kind, then total the dollar amounts in
column C
The B data is either text, numeric or empty cells I just want total
dollars of column C that corresponds to nonblank cells in column B and
2007 in column A
Is that possible?