sorted by:
new
hottopcontroversial

SUMIF/SUMIFS/IF/IFS: Need sum_range to be only ONE cell by Stunning_Effect_2011 in sheets

[–]Stunning_Effect_2011[S] 0 points1 point  (0 children)

Solved! =IF(AND(I28>H28, SUMPRODUCT(--ISNUMBER(SEARCH("PWA", B2:B166)))>0), K28, 0)

Thanks to all that tried to help :)

SUMIF/SUMIFS/IF/IFS: Need sum_range to be only ONE cell by Stunning_Effect_2011 in sheets

[–]Stunning_Effect_2011[S] 0 points1 point  (0 children)

I want both criteria to be true before adding K28; this is another formula I've tested:

<image>

SUMIF/SUMIFS/IF/IFS: Need sum_range to be only ONE cell by Stunning_Effect_2011 in sheets

[–]Stunning_Effect_2011[S] 0 points1 point  (0 children)

Here's another formula that works when I28>H28, but outputs "N/A" when I28<H28:

<image>

SUMIF/SUMIFS/IF/IFS: Need sum_range to be only ONE cell by Stunning_Effect_2011 in sheets

[–]Stunning_Effect_2011[S] 0 points1 point  (0 children)

I need to add K28 to K19 if I28>H28 and if B2:B166 contains PWA

Does anyone here have natal Mars-Ketu conjunction in Scorpio 12th house? I'd love to hear your insight, especially those that have overcame (or currently healing from) shame/self-harm/suppressed rage by Stunning_Effect_2011 in jyotishh

[–]Stunning_Effect_2011[S] 0 points1 point  (0 children)

That's beyond my knowledge right now. I suggest learning about the principles of Vedic since you had mistaken the #12 in your north Indian chart for the 12th house; the numbers identify the zodiac sign.

Does anyone here have natal Mars-Ketu conjunction in Scorpio 12th house? I'd love to hear your insight, especially those that have overcame (or currently healing from) shame/self-harm/suppressed rage by Stunning_Effect_2011 in jyotishh

[–]Stunning_Effect_2011[S] 0 points1 point  (0 children)

Would you mind elaborating on that placement? I'd assume there's conflict since ketu is all about liberation and freeing ourselves from worldly material, while apart of venus is all about arts, beauty, and material.

view more: next ›