- 584K Members
- 7,436 Online
- 706K Conversations

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Home
- :
- Excel
- :
- General Discussion
- :
- Counting in IF stmt

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Conversation Options

- Subscribe to RSS Feed
- Mark Conversation as New
- Mark Conversation as Read
- Pin this Conversation for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-29-2019 11:25 AM

I have a small Investment spreadsheet. Currently I'm tracking six symbols. One column, H5 - H10, tracks the change for each symbol. I'm trying to do two basic things, count the number of winners and count the number of losers in cells B13 and B14 and secondly, total the winnings and loses in B15 and B16.

Labels:

7 Replies

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-29-2019 01:25 PM

COUNTIF() shall work, but better if you provide small sample file

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-29-2019 05:11 PM

Thanks for the help.

Group 3A | ||||||||||||||||||||||

TRADE | TRADE | OPEN TRADE | CLOSED | |||||||||||||||||||

ENTRY DATE | SYMBOL | L/S | SHARES | ENTRY PRICE | LAST PRICE | CHANGE | $ GAIN/LOSS | ROI | TRADE P&L | RISK | ||||||||||||

66/24/19 | FFXE | L | 1 | 108.26 | 108.27 | $ 0.0 | $ 0.01 | 0.0% | ||||||||||||||

66/24/19 | GLDGLD | L | 1 | 133.5 | 133.2 | $ (0.30) | $ (0.30) | -0.2% | ||||||||||||||

66/24/19 | QQQ | L | 1 | 188.5 | 186.74 | $ (1.76) | $ (1.76) | -0.9% | ||||||||||||||

66/24/19 | TLT | L | 1 | 132 | 132.81 | $ 0.81 | $ 0.81 | 0.6% | ||||||||||||||

66/24/19 | VXX | S | 1 | 26.6 | 26 | $ (0.60) | $ 0.60 | 2.3% | ||||||||||||||

66/24/19 | XOP | S | 1 | 26 | 27.25 | $ 1.25 | $ 1.25 | 4.81% | ||||||||||||||

Open | Trades | 614.86 | 614.27 | $ 61.00 | 9.92% | $ - | #DIV/0! | |||||||||||||||

Stocks | 6 | |||||||||||||||||||||

Losers | #NAME? | Open P&L | $ 61.00 | |||||||||||||||||||

Winners | ||||||||||||||||||||||

$ winners | Open Trade | Avg ROI | 2.35% | |||||||||||||||||||

$ Losers | ||||||||||||||||||||||

Avg win | Closed P&L | $ - | ||||||||||||||||||||

Avg lose | ||||||||||||||||||||||

Profit Factor | Return On Risk | = | ||||||||||||||||||||

Weekly Close | Open & Closed | Equity Change | Weekly Acct | |||||||||||||||||||

Date | P/L | Plus/Minus | Gain/Loss % |

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-29-2019 05:47 PM

I'm trying =COUNTIF(H5,<0,"") for the losers but it's not working. BTW - is there a SUMIF () for the totals ?

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-29-2019 10:50 PM

The COUTIF() function only has 2 parameters: **range** and **criteria**

The formula will work is you select the collection of cells containing winners as losers, making that your range (H5:H10) and your criteria to "L"

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-30-2019 10:59 AM

We may only make a guess where is what in your data. If H5:H10 is the range with numbers in dollars, when number of losers

=COUNTIF(H5:H10,"<0")

and for winners

=COUNTIF(H5:H10,">0")

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-30-2019 06:39 PM

Thanks so much Sergei, the formulas worked perfect.

In order to total the numbers for losers and winners, is there an IF statement I use, perhaps =SUMIF () ?

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-01-2019 01:35 AM

Related Conversations

How to keep hyperlink in cells being accessed with IF function across workbooks?

jandy
in
Excel
on
07-13-2019
117
Views

0 Likes

2 Replies

IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS

thomasea
in
Excel
on
03-20-2019
471
Views

0 Likes

6 Replies

Terminal Server Deployment - Users Constantly Have to Log Into Teams

bennjimin
in
Microsoft Teams
on
12-14-2018
1,723
Views

0 Likes

4 Replies

Count entries on a category omitting duplicates and blank cells

Vicente Heyermann Vial
in
Excel
on
03-16-2018
1,859
Views

0 Likes

9 Replies

Share

Microsoft Store

Education

Developer