Forum Discussion
Solved
IF formula to calculate outcome
Can someone please assist or give suggestions I am trying to create a formula where you can see I've highlighted (green boarder) around a cell What I am trying to create is from the blu...
=SUMPRODUCT(($C$1:$E$1=$C13)*($C$2:$E$10=D$12))You can try this formula for the data layout of the example.
=SUMPRODUCT(($C$1:$E$1=$C13)*($C$2:$E$10=D$12))You can try this formula for the data layout of the example.
OliverScheurich thank you so much. I knew someone would have an answer ASAP. Have a good day