Hi! I am trying to tabulate data count and also conduct summation with multiple conditions:

logic: countif (A1:A99=true AND B1:B99="Open" AND C1:C99="Q1")
logic: if (A1:A99="X"), sum (corresponding columns), else ("check")

It would be great if you can either post the reply or PM me; I can send a sample spreadsheet should my post is not clear.

Thanks for your help!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
For any journey one makes
Even if the displacement equates to zero
Something is being gained
For the distance travelled is certainly not zero
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~