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...
Just one more question
I have to add two sumproduct command in one cell as follows:
SUMPRODUCT(--(B$3:B$170=B15);(Q$3:Q$170=$P198)*(S$3:S$170)*(T$3:T$170))+SUMPRODUCT(--(B$3:B$170=B$28);(Q$3:Q$170=$P198)*(S$3:S$170)*(T$3:T$170))
Is there a shorter format to combine --(B$3:B$170=B15) and...
Dear NARAYANK991 and other folks
Many thanks to ARAYANK991 as his solution solved the problem.
I was unaware of the difference between "" and zero and assumed both as null. But putting 0 instead of "" solved the problem.
May I buy a mug of beer for you.
Here is my table
Original one
H...
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...