I have tried to solve the following problem with a SUMIF, but I think I am walking down the wrong path....
In Column A I have numbers 0 to 12. There will be several 0's at various points down column A .
Every time a cell in Column A is 0 (not when numbers between 1 and 12) I wish to add up the number 2 collumns over (Column C).
As mentioned, I was not able to solve this with SUMIF, but since the dataset is very big (over 600 rows "long") I hope to find the most Efficient formula... well firstly I guess I hope to find one that works.
Thanks to any who can help.
In Column A I have numbers 0 to 12. There will be several 0's at various points down column A .
Every time a cell in Column A is 0 (not when numbers between 1 and 12) I wish to add up the number 2 collumns over (Column C).
As mentioned, I was not able to solve this with SUMIF, but since the dataset is very big (over 600 rows "long") I hope to find the most Efficient formula... well firstly I guess I hope to find one that works.
Thanks to any who can help.