Hey, I'm an excel novice and could really do with some help please. I need to calculate how many instances there are of one Criteria in one column and two in another column as one formula. Basically trying to figure out how many approved docs I have at on two types of status'. In one column I have whetheritis approved or not and another tells me all the different status of the doc. Hope that makes sense...
As an example where you want to count how many instances of "Approved" in Column A
=COUNTIF(A:A,"Approved")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I need to find out how many ifc and ifr's are at ac?
doc number status client approval
1 ifu ac
2 1
3 rec
4 2
5 3
6 ifa
7 ifc ac
8 ifu ac
9 ifu ac
10 ifc
11 rec
12 ifr acc
13 rec
14 1
15 ifa
16 ifc ac
17 ifr r
18 ifa ac
19 1
20 rec
21 2
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
example excel instance.xlsx
Hopefully an example has attached....
Maybe this:
=SUM(COUNTIFS(B:B,{"IFU","IFC"},C:C,"AC"))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Perfect, thanks!
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks