Hi all,
Need help in putting countif formula with multiple criteria.
Excel file attached with necessary details.
Pl. help.
Thanks,
Nagesh.
Hi all,
Need help in putting countif formula with multiple criteria.
Excel file attached with necessary details.
Pl. help.
Thanks,
Nagesh.
the countif function can be replaced by countifs which works in virtual l thesame way
B18
=COUNTIFS($B$2:$B$8,$A18,C$2:C$8,"P")
I have data for one year. The formula should consider the Dates also. I used below formula and getting error message.
=COUNTIFS($B$2:$B$8,$A18,C$2:C$8,$C$1:$E$1,B$17,"P")
If possible pl. help on the 2nd requirement also (formula at J18).
Thanks,
Nagesh.
1. You have an incorrect/missing criteria in the 2nd part...
=COUNTIFS($B$2:$B$8,$A18,....C$2:C$8,...requires criteria...$C$1:$E$1,B$17,"P")
2. your ranges need to be all either column OR rows, you cant mix them up...
=COUNTIFS($B$2:$B$8,$A18,C$2:C$8,$C$1:$E$1,B$17,"P")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
ARRAY function in J18 then dragged across.
How ARRAY formula is enteredPlease Login or Register to view this content.
Paste Formula in the cell.
Press F2
Hold Shift+ Ctrl Keys and hit Enter key.
Now the formula is surrounded by {} by excel.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Just be aware that array formulas have a tendency to slow sheets down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks