I have a table of utility type and their cost.
A sample is as follows
Utility Date Cost
gas Jan. 2013 100US$
gas Feb. 2013 95$
electricity Jan 2013 200US$
electricty Feb 2013 195 $
Telephone Jan 2013 500$
Telephone Feb 2013 300$
gas March 2013 200$
and goes on...
I am trying to use sumproduct function in a table. I have used it a lot and know how it operates.
In one of my columns, I have blank cells and other cells are text (like 1F25 in column A). In order to use it in sumproduct, I make two different columns aS FOLLOWS:
Column Q...