Hello everyone!
Could someone please give me a hand?
I am trying to this:
Given a Table array, IF a ROW contains a certain TEXT, I want to make the SUM of the cells on those ROWs on all the COLUMNS
In the example below, the result I am looking for is: SUM of all the Clicks from all months (M1 to M4 are Month 1, Month 2...)
What I have now is : =sumif(E13:I18,"*Click*",F13:F18), but it only returns the SUM of Clicks in M1.
Does anyone know if the sum if doable?
Thank you!
Could someone please give me a hand?
I am trying to this:
Given a Table array, IF a ROW contains a certain TEXT, I want to make the SUM of the cells on those ROWs on all the COLUMNS
In the example below, the result I am looking for is: SUM of all the Clicks from all months (M1 to M4 are Month 1, Month 2...)
What I have now is : =sumif(E13:I18,"*Click*",F13:F18), but it only returns the SUM of Clicks in M1.
Does anyone know if the sum if doable?
Thank you!